[windows2000] Re: Sql 2000 question

  • From: "Sullivan, Glenn" <GSullivan@xxxxxxxxxxxxxx>
  • To: <windows2000@xxxxxxxxxxxxx>
  • Date: Wed, 5 Dec 2007 14:45:26 -0500

BTW, if you have a 350mb database, and a 69GB log file, there is
something seriously wrong with your backup strategy... I would
definately look at that as well.

Glenn Sullivan, MCSE+I MCDBA
David Clark Company Inc. 



From: windows2000-bounce@xxxxxxxxxxxxx
[mailto:windows2000-bounce@xxxxxxxxxxxxx] On Behalf Of Patrick
Posted At: Wednesday, December 05, 2007 7:32 AM
Posted To: Windows 2000
Conversation: [windows2000] Sql 2000 question
Subject: [windows2000] Sql 2000 question

Hi Guys,
Not quite sure if I would find the answer here, but I will ask anyway.
We have an SQL server 2000, with a DB Fire-fly2000.mdb (350mb), and a
corresponding logfile Fire-fly2000.ldf (69GB). Now the issue is that we
want to shink the .ldf file cos of disk space, but we are having a
problem with the naming convention. SQL does not like - in names. Is
there a way we can get around this?


Never miss a thing. Make Yahoo your homepage.

Other related posts: