Execute the following commands: DBCC SHRINKFILE(pubs_log, 2) BACKUP LOG pubs WITH TRUNCATE_ONLY DBCC SHRINKFILE(pubs_log,2) This will reduce the transaction log for the “pubs” database to 2MB. Bookmark on Delicious Digg this post Recommend on Facebook share via Reddit Share with Stumblers Tweet about it Subscribe to the comments on this post Print for later Bookmark [...]
Execute the following commands:
DBCC SHRINKFILE(pubs_log, 2) BACKUP LOG pubs WITH TRUNCATE_ONLY DBCC SHRINKFILE(pubs_log,2)
This will reduce the transaction log for the “pubs” database to 2MB.
