Transaction Log 자르기
SQL / 2010. 5. 11. 13:57
Transaction Log 자르기
1. MS-SQL 2005
backup log [dbname] with no_log
dbcc shrinkfile('IGROO_DB_Log',1)
2. MS-SQL 2008
ALTER DATABASE [dbname] SET RECOVERY SIMPLE
GO
DBCC SHRINKFILE(2, 1)
GO
ALTER DATABASE [dbname] SET RECOVERY FULL