Monday, 3 December 2012

Shrink database of sql server 2005


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

No comments:

Post a Comment