Databases
MS SQL 트랜잭션 로그를 줄이는 방법
duraboys
2011. 5. 13. 11:04
http://faq.hostway.co.kr/xe/win_db/757
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명