Loading ...

SQL: Shrink transaction log with query | CodeAsp.Net

SQL: Shrink transaction log with query

 /5
0 (0votes)

Below is the query which you can use to shrink the transcation log:

USE AdventureWorks2008R2;
GO
-- Truncate the log by changing the database recovery model to SIMPLE.
ALTERDATABASE AdventureWorks2008R2 SET RECOVERY SIMPLE; GO -- Shrink the truncated log file to 1 MB.
DBCC SHRINKFILE (AdventureWorks2008R2_Log,1); GO -- Reset the database recovery model.
ALTERDATABASE AdventureWorks2008R2 SET RECOVERY FULL; GO

Comments (no comments yet)

Top Posts