Recover Suspected SQL Database Using Query

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

Previous Post Next Post

Most Visited

Follow us on WhatsApp, Telegram Channel, Twitter and Facebook for all latest updates

Search Content of www.potools.blogspot.com @