Monday, September 20, 2010

Reduce Log size during Reindexing

USE [Customer]
GO

SELECT *
FROM sysfiles
WHERE name LIKE '%LOG%'
GO

DBCC SHRINKFILE (Customer_Log, 1)
GO

BACKUP LOG Customer WITH NO_LOG
GO

DBCC SHRINKFILE (Customer_Log, 1)
GO

BACKUP LOG Customer WITH TRUNCATE_ONLY
go

DBCC SHRINKFILE (Customer_Log, 1)
GO

No comments: