Shrinking Log File SQL 2005 / 2008

by Nathan 17. March 2011 07:55

Here is the code to shrink a bloated log file:

 

SQL 2005

DBCC SHRINKFILE('<LogFileName>', 1)
BACKUP LOG <DatabaseName> WITH TRUNCATE_ONLY
DBCC SHRINKFILE('<LogFileName>', 1)

SQL 2008

USE <databaseName>
GO

ALTER DATABASE <databaseName> Set Recovery Simple
GO

ALTER DATABASE <databaseName> Set Recovery Full
GO

DBCC SHRINKFILE ('<LogFileName>', 1)
GO


FINDING NAME OF SQL LOG AND DATABASE FILE

To find the logfile and database names you can execute the below procedure

use <databaseName>

exec sp_helpfile

Tags:

SQL

Add comment


(Will show your Gravatar icon)

  Country flag

biuquote
  • Comment
  • Preview
Loading



Powered by BlogEngine.NET 1.6.1.0
Theme by Mads Kristensen