2. Create new database with same dbname, file names and locations.
3. Stop services
4. Copy good mdf and replace new empty mdf
5. Restart services - database will be suspect
6. Setup server to updates to sysdatabases:
Use Master
Go
sp_configure 'allow updates', 1
reconfigure with override
Go
7. Put database in emergency mode:
update sysdatabases set status = 32768 where name = '
8. Stop and start services again - database should be marked in emergency mode
9. Rebuild the log file:
DBCC TRACEON (3604)
DBCC REBUILD_LOG('
Go
10. DBCC CHECKDB(
No comments:
Post a Comment