«
»

Truncate Logfile SQL Server – Out Of Memory Error

Run this First:

BACKUP LOG DatabaseName WITH TRUNCATE_ONLY

Then Run this:

DBCC SHRINKDATABASE (DatabaseName)

Note: Should only be used on development machines..I believe, becasue will erase your log files

This entry was posted on Tuesday, March 3rd, 2009 at 5:51 pm and is filed under Technology. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.

Leave a Reply