Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2004-10-25 : 16:22:25
|
| Mike writes "I'm using Disk Xtender 2000 which was made by OTG Software then Legato and now EMC. I have SQL 2000 on an NT 4.0 PC. I have a 38 gig .ldf file which is OTG03.ldf and a 2 gig mdf file which is OTG03.mdf I'm running out of hard drive space. Is there a way that I can shrink the .ldf file? I'm not a DBA so if you would be specific it would greatly be appreciated as is all help." |
|
|
MuadDBA
628 Posts |
Posted - 2004-10-25 : 16:47:21
|
| This topic has been discussed many many times, use the search feature and type SHRINK LOG and you should find the answer you need. |
 |
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2004-10-25 : 22:58:33
|
| just curious, if you already did the process of backup and shrinkfile, how long did it take?--------------------keeping it simple... |
|
|
|
nr
SQLTeam MVY
12543 Posts |
|
|
|
|
|
38 gig .ldf file needs shrunk