MS-SQL 2000 : Truncate transaction log By admin on June 17, 2009 in Misc Execute the following commands: DBCC SHRINKFILE(pubs_log, 2) BACKUP LOG pubs WITH TRUNCATE_ONLY DBCC SHRINKFILE(pubs_log,2) 123 DBCC SHRINKFILE(pubs_log, 2)BACKUP LOG pubs WITH TRUNCATE_ONLYDBCC SHRINKFILE(pubs_log,2) This will reduce the transaction log for the “pubs” database to 2MB. No related posts.
