MSSQL 미러링 환경에서 로그 축소 방법

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