Saturday, May 8, 2010

Shrinking Truncate Log File – Log Full

Tran log full and disk space also full.
Can not take the tran log on same disk.So take tran log to diffrent disk.then follow the 3 steps 2 or 3 times and log space will come to normal.

USE DatabaseName
GO
1. DBCC SHRINKFILE(, 1)
2. BACKUP LOG WITH TRUNCATE_ONLY
3. DBCC SHRINKFILE(, 1)
GO

--Balki