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);