[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?
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:
