SQL Suspected database recovery
exec sp_configure 'allow updates',1
above run in master
reconfigure with override
above run in master
begin tran update master..sysdatabases
set status=32768 where name='post'
if @@rowcount = 1
begin commit tran raiserror('emergency mode set',0,1)
end
else
begin rollback raiserror('unable',16,1)
end
dbcc rebuild_log('post','d:\post.log')
above run in master
Updates:
Follow us on WhatsApp, Telegram Channel, Twitter and Facebook for all latest updates
Post a Comment