Windows DB
MS SQL 트랜잭션 로그를 줄이는 방법
2008.09.18 03:08
1) sp_dboption 'DB명', 'trunc. log on chkpt.', 'true' [실행]
2) DBCC SHRINKDATABASE(DB명, TRUNCATEONLY) [실행]
3) sp_dboption 'DB명', 'trunc. log on chkpt.', 'false' [실행]
4) USE Master
GO
BACKUP LOG sqldb WITH TRUNCATE_ONLY
USE sqldb
DBCC SHRINKFILE(sqldb_log,1000)
sqldb = DB명
2) DBCC SHRINKDATABASE(DB명, TRUNCATEONLY) [실행]
3) sp_dboption 'DB명', 'trunc. log on chkpt.', 'false' [실행]
4) USE Master
GO
BACKUP LOG sqldb WITH TRUNCATE_ONLY
USE sqldb
DBCC SHRINKFILE(sqldb_log,1000)
sqldb = DB명
