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 |
|
RobMarsh
Starting Member
28 Posts |
 Posted - 2002-05-03 : 12:37:32
|
| SQL Server 7.0 I need to shrink a log file that has gotten way too big - (its 1500 Meg with only 30 used). No matter what I try to do, it won't shrink.The entrerprise manager is lying to me when it says it has successfully shrunk it...Is there a workaround to this? I can't take the DB offline as its a live system.Thanks,Rob |
|
|
KnooKie
Aged Yak Warrior
623 Posts |
Posted - 2002-05-03 : 12:45:41
|
| Rather than me write out solutions i'd suggest that your best bet is to search this site for one. This question has come up so many times i'd almost guarantee you'll find a suitable answer.Might also be worth reading about service pack 4 which has recently been released for SQL7.Paul |
 |
|
|
chadmat
The Chadinator
1974 Posts |
Posted - 2002-05-03 : 13:24:48
|
| http://support.microsoft.com/default.aspx?scid=kb;en-us;Q256650&SD=MSKB&-Chad |
|
|
|
|
|
|
Shrinking a Log File...