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 DATABASE
alphago
SET RECOVERY FULL; GO
No comments:
Post a Comment