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
November | 2012 | November 2012 – Aron's Tech Blog

Monthly Archives: November 2012

MSSQL

Truncating SQL 2008 Transaction Log

November 28, 2012 – 1:46 pm

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
Permalink | Comments Off on Truncating SQL 2008 Transaction Log