Senin, 17 Juni 2013

Reduce SQL Sever Log Size (.LDF File)

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

1 komentar:

lakeshiaiacobelli mengatakan...

Casinos Near Philadelphia (IL) - Mapyro
Find Casinos Near 구미 출장샵 Philadelphia (IL) in real-time and see 제주 출장샵 activity. the 1 casino floor 광주 출장안마 at Harrah's Philadelphia in 청주 출장마사지 Chester, 문경 출장마사지 PA.

Posting Komentar