Thursday 27 March 2014

Remove Suspect Mode Database Issue

use master
ALTER DATABASE StrDownload_new SET  EMERGENCY
Go
ALTER DATABASE  StrDownload_new SET SINGLE_USER
Go
DBCC CHECKDB (StrDownload_new, REPAIR_ALLOW_DATA_LOSS)
GO
ALTER DATABASE  StrDownload_new SET MULTI_USER
Go

No comments:

Post a Comment