May 14, 2015
RECOVER SUSPECTED SQL DATABASE USING QUERY
Posted by Admin Labels: SQL, SQL 2000 Suspect
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
No comments:
Post a Comment