Notice: Function WP_Block_Type_Registry::register was called incorrectly. Block type "core/video" is already registered. Please see Debugging in WordPress for more information. (This message was added in version 5.0.0.) in /var/www/html/blog_tech/wp-includes/functions.php on line 6121
Truncating SQL 2008 Transaction Log | Truncating SQL 2008 Transaction Log – Aron's Tech Blog

Truncating SQL 2008 Transaction Log

Use the following to truncate a log, the TestDbLog is the logical file name of the log file.

USE TestDb 
GO
ALTER DATABASE TestDb SET RECOVERY SIMPLE WITH NO_WAIT
DBCC SHRINKFILE(TestDbLog, 1)
ALTER DATABASE TestDb SET RECOVERY FULL WITH NO_WAIT
GO
Posted on November 28, 2012 by . This entry was posted in MSSQL. Bookmark the permalink.

Comments are closed.