Shrink DB Log file in SQL Server 2008


USE DatabaseName 
Go 

--Get DB/LOG fileid and name
SELECT file_id, name
FROM sys.database_files;
GO


--Check if there is old active transaction preventing shrinking db log
DBCC OPENTRAN (DatabaseName) WITH TableResults
GO 
--Change Recovery Mode from Full to Simple
ALTER DATABASE DatabaseName SET RECOVERY SIMPLE WITH No_Wait

DBCC SHRINKFILE('Database_log',1)

--Change Recovery Mode from Simple back to Full
ALTER DATABASE DatabaseName SET RECOVERY FULL WITH No_Wait


posted @ 2011-04-23 09:41  Allen Xu  阅读(267)  评论(0编辑  收藏  举报