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 |
|
markliberty
Starting Member
4 Posts |
 Posted - 2007-07-17 : 12:05:07
|
I have a sql 2005 system and have a very large 25gb ldf file and a 200mb database.Someone has set the initial size at 25gb so shrinking the file will not help.I need to remove/add the file to gain space on the drive.SQL 2000 you could just detach the DB and rename the ldf file and attach the db back and you are done. With 2005 you cannot do that.  |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-07-17 : 13:04:37
|
| Backup log with truncate only option, set db the simple recovery model, then shrink log file. Once done, set recovery model back. If it's full recovery, you need backup log periodically. |
 |
|
|
|
|
|
resize LDF file