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 |
|
qman
Constraint Violating Yak Guru
442 Posts |
 Posted - 2011-12-04 : 11:01:59
|
| I have no space left on a log drive, and as a result am unable to reduce the size of the logs.Can someone please tell me how to force the logs to truncate?I am unable to run:DBCC SHRINKDATABASE (MIBBilling, TRUNCATEONLY);I am using SQL 2008 |
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2011-12-04 : 11:36:06
|
| Please read through this - [url]http://www.sqlservercentral.com/articles/64582/[/url] and this - http://www.sqlservercentral.com/articles/Transaction+Log/72488/If you have to shrink, just shrink the log file, not the entire database. It'll have less impact. Shrink the entire DB and you'll need to rebuild indexes afterwards.--Gail ShawSQL Server MVP |
 |
|
|
|
|
|
Unable to reduce log size