[windows2000] Re: Sql 2000 question

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

First run a backup.
Detach the database with the detach command.
Rename the files without the hyphen.
Reattach the database with the attach command.
Run another backup, making sure it is a full backup.
Do a DBCC_Shrinkdatabase command on the database.
Help for all of the above is in SQL Book Online, or just shout...

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: