December 30, 2006 by pinaldave
Sometime, it looks impossible to shrink the Truncated Log file. Following code always shrinks the Truncated Log File to minimum size possible.
USE DatabaseName
GO
DBCC SHRINKFILE(
BACKUP LOG
DBCC SHRINKFILE(
GO
1/1/09
SQL SERVER - Shrinking Truncate Log File - Log Full
SQL SERVER - Shrinking Truncate Log File - Log Full
December 30, 2006 by pinaldave
Sometime, it looks impossible to shrink the Truncated Log file. Following code always shrinks the Truncated Log File to minimum size possible.
USE DatabaseName
GO
DBCC SHRINKFILE(, 1)
BACKUP LOG WITH TRUNCATE_ONLY
DBCC SHRINKFILE(, 1)
GO
December 30, 2006 by pinaldave
Sometime, it looks impossible to shrink the Truncated Log file. Following code always shrinks the Truncated Log File to minimum size possible.
USE DatabaseName
GO
DBCC SHRINKFILE(
BACKUP LOG
DBCC SHRINKFILE(
GO
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment