One of my client database log size is growing ridiculously big. Over 40 GB, I need to shrink the file size since I don’t really need to recover to a point in time. My client periodically backup the database. After googling around, I found these steps:
backup log DatabaseName with truncate_only -- This statement will mark inactive part of log
dbcc shrinkfile(DatabaseName_Log) -- This statement will release the marked inactive space to OS
After this my log file size reduced to marely 1 MB. However since my backup chain is now broken, I no longer able to use TL backup for recovery so I have to do full backup of the database.
Source : http://social.msdn.microsoft.com/Forums/en-US/sqltools/thread/95b0ef9c-3afe-44c9-b233-3b3df4c75124
0 komentar:
Posting Komentar