| « Rename file via scripted FTP | Turn on register_long_arrays for PHP on Plesk » |
MS-SQL 2000 : Truncate transaction log
06/17/09
MS-SQL 2000 : Truncate transaction log
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.
Comment feed for this post
