Monday, 3 December 2012

Shrink database of sql server 2005


DBCC SHRINKFILE(<TransactionLogName>, 1)
BACKUP LOG <DatabaseName> WITH TRUNCATE_ONLY
DBCC SHRINKFILE(<TransactionLogName>, 1)

Posted by at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)