IN SQL 2005 DATABASE SUSPECTED RECOVERY QUERY, FOLLOWING QUERY RUN ONE BY ONE WITH CHANGE OF DATABASE NAME
ALTER DATABASE POSTMAN SET EMERGENCY
ALTER DATABASE POSTMAN SET SINGLE_USER
DBCC CheckDB (POSTMAN , REPAIR_ALLOW_DATA_LOSS)
ALTER DATABASE POSTMAN SET MULTI_USER
ALTER DATABASE POSTMAN SET EMERGENCY
ALTER DATABASE POSTMAN SET SINGLE_USER
DBCC CheckDB (POSTMAN , REPAIR_ALLOW_DATA_LOSS)
ALTER DATABASE POSTMAN SET MULTI_USER
No comments:
Post a Comment