LinkedIn

Thursday, November 21, 2013

Clearing Transactional Log File

The transaction log for database 'DatabaseName' is full. To find out why space in the log cannot be reused, see the log_reuse_wait_desc column in sys.databases:
Use the following db scripts to clear the log:
use DBName
dbcc shrinkfile(2,2048)

No comments:

Post a Comment