Thread: MS SQL Server General Questions/Physically Cut / shrink / truncate database LOG / transaction file

Physically Cut / shrink / truncate database LOG / transaction file

Please make copy of your database first!


USE [MyDB_2008]

GO

ALTER DATABASE MyDB_2008 SET SINGLE_USER

GO

DBCC CHECKDB ('MyDB_2008',REPAIR_REBUILD)

GO

DBCC SHRINKFILE(MyDB_2008, 2) ALTER DATABASE MyDB_2008 SET RECOVERY SIMPLE;

GO

DBCC SHRINKFILE(MyDB_2008_LOG, 2)

GO

ALTER DATABASE MyDB_2008 SET RECOVERY FULL

GO

ALTER DATABASE MyDB_2008 SET MULTI_USER

GO

-- 25/09/2008 21:05:44: post edited by sergey.