1. dbcc checkdb 처리시 오래 걸림
ALTER DATABASE DB_Name SET EMERGENCY
go
ALTER DATABASE DB_Name SET SINGLE_USER WITH ROLLBACK IMMEDIATE
go
DBCC CHECKDB('DB_Name',REPAIR_ALLOW_DATA_LOSS)
go
ALTER DATABASE DB_Name SET MULTI_USER WITH ROLLBACK IMMEDIATE
'Common Admin' 카테고리의 다른 글
| Admin::VLDB성능관리#1 (0) | 2010.04.04 |
|---|---|
| Admin::SQL Server wait types (0) | 2010.03.28 |
| SQL 2008-변경 내용 추적 (0) | 2009.12.28 |
| sql2008::CDC(Change Data Capture) (1) | 2009.12.28 |
