User Tools

Site Tools


notes:sql:shrinklog

Shrinking Log in SQL Server

CHECKPOINT
 
EXEC sp_helpdb 'MyDatabase'
 
DBCC SHRINKFILE(MyDatabase_log,10)
 
BACKUP LOG MyDatabase WITH TRUNCATE_ONLY
 
EXEC sp_helpdb 'MyDatabase'
notes/sql/shrinklog.txt · Last modified: 2015/06/24 by admin