Tuesday, 21 August 2012

SQL 2005 Help~.~c

SQL Server 2005: Shrink and Truncate Log file size
http://www.sqlcleanup.com/2008/sql-2005-truncating-log-files-and-recovering-space/
USE 
GO
BACKUP LOG  WITH TRUNCATE_ONLY
GO
DBCC SHRINKFILE (, 1)
GO
DBCC SHRINKFILE (, 1)
GO
exec sp_helpfile

No comments:

Post a Comment