[windows2000] Re: Sql 2000 question
- From: "Sullivan, Glenn" <GSullivan@xxxxxxxxxxxxxx>
- To: <windows2000@xxxxxxxxxxxxx>
- Date: Wed, 5 Dec 2007 14:43:19 -0500
Sure.
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?
Thanks
________________________________
Never miss a thing. Make Yahoo your homepage.
<http://us.rd.yahoo.com/evt=51438/*http://www.yahoo.com/r/hs>
Other related posts:
