On Transact-SQL Window, run the below statement;
ALTER DATABASE MyDatabaseName SET RECOVERY SIMPLE
DBCC SHRINKFILE (MyDatabaseName_Log, 1)
Go
Once the Log File has been truncated, run the below command
to put it back the database into full recovery mode using below statement;
ALTER DATABASE MyDatabaseName SET RECOVERY FULL
GO
No comments:
Post a Comment