Danh hiệu: Kê Vương
Gia nhập: 23-01-2011(UTC) Bài viết: 2,113  Đến từ: HCM Thanks: 4 times
Được cảm ơn: 300 lần trong 220 bài viết
|
Chạy script sau Mã:
-- sp_resetstatus turns off the "suspect" flag on a database
EXEC sp_resetstatus [DatabaseName]
-- Marking database READ_ONLY, disable logging,
-- and limiting access only to members of the sysadmin fixed server role
ALTER DATABASE [DatabaseName] SET EMERGENCY
-- Checks the logical and physical integrity of all the objects in the specified database
DBCC checkdb([DatabaseName])
-- This query will rollback any transaction which is running on that database
-- and bring SQL Server database in a "single user" mode
ALTER DATABASE [DatabaseName] SET SINGLE_USER WITH ROLLBACK IMMEDIATE
DBCC CheckDB ([DatabaseName], REPAIR_ALLOW_DATA_LOSS)
-- Set database accessibility to it's original state, allowing all logins
ALTER DATABASE [DatabaseName] SET MULTI_USER
|
