Tags


SHRINK Log file in SQL Server 2008

 

To shrink log file in Sql Server::

Use DATABASENAME
GO
Alter Database DATABASENAME Set Recovery Simple
GO
DBCC SHRINKFILE (‘LOGFILENAME_log’, 1000)
GO
Alter Database DATABASENAME Set Recovery Full
GO

 

Enjoy!!!

Advertisements