One day i tried to shrink my log file on sql server, but the file xxx_log ( file.ldf –physical file ) still on huge size. Previous script that i use :
BACKUP LOG DATABASE WITH TRUNCATE_ONLY
And i get this issue : truncate_only' is not a recognized BACKUP option
This issue happen on SQL Server 2008, and after i run this scripts it work for me, hope it will work with you.
-- this script is work on sql server 2008, it work for me-- Use sp_helpfile to identify the logical fileUSE DatabaseName;GO-- Truncate the log by changing the database recovery model to SIMPLE.ALTER DATABASE DatabaseNameSET RECOVERY SIMPLE;GO-- Shrink the truncated log file to 1 MB.-- the log file name (dbname_log)DBCC SHRINKFILE (DatabaseName_log , 1);GO-- Reset the database recovery model.ALTER DATABASE DatabaseNameSET RECOVERY FULL;GO
No comments:
Post a Comment