Sql Server Database in Recovery Mode
declare @ veritabani as nvarchar ( max ) ; declare @ sql as nvarchar ( max ) ; set @ veritabani = ‘VeriTabanı’ ; set @ sql = ‘USE master; EXEC sp_resetstatus ‘ ” + @ veritabani + ” ‘; USE ‘ + @ veritabani + ‘; DBCC CHECKDB WITH NO_INFOMSGS; ALTER DATABASE ‘ + @ veritabani + ‘ SET EMERGENCY ALTER DATABASE ‘ + @ veritabani + ‘ SET SINGLE_USER DBCC CHECKDB(‘ + @ veritabani + ‘, REPAIR_ALLOW_DATA_LOSS) WITH NO_INFOMSGS; USE ‘ + @ veritabani + ‘; DBCC CHECKDB WITH NO_INFOMSGS; ‘ exec ( @ sql ) ;