4 Ağustos 2016 Perşembe

MS-SQL / How to repair suspect sql db

Suspect olmuş bir veritabanını onarma:

EXEC sp_resetstatus [DB_Name];
ALTER DATABASE [DB_Name] SET EMERGENCY
DBCC checkdb([DB_Name])
ALTER DATABASE [DB_Name] SET SINGLE_USER WITH ROLLBACK IMMEDIATE
DBCC CheckDB ([DB_Name], REPAIR_ALLOW_DATA_LOSS)

ALTER DATABASE [DB_Name] SET MULTI_USER

Hiç yorum yok:

Yorum Gönder

Problem MS SQL Server instances disappear from SQL Intelligent Policy and previously discovered Availability Groups (AG) in NetBackup. Cause...