If database is in suspect mode , follow below steps only and get relief with in 10 minitus.
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
if database properties are locked due to permissions with following screen
use DB_Name exec sp_changedbowner 'User_name'
1 comment:
Solving troubles with sql databases it's task for repair database sql. The program starts under low system requirements, it is able to demonstrate the results of restoring.
Post a Comment