USE alphago; GO -- Truncate the log by changing the database recovery model to SIMPLE. ALTER DATABASE AdventureWorks2008R2
SET RECOVERY SIMPLE; GO -- Shrink the truncated log file to 1 MB.
DBCC SHRINKFILE (alphago_Log, 1); GO -- Reset the database recovery model. ALTER DATABASEalphagoSET RECOVERY FULL; GO
No comments:
Post a Comment