Corruption of Syslogs (log suicide)

From SybaseWiki
Revision as of 14:03, 30 March 2009 by Bobh (Talk | contribs)

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search

Log Suicide

Note: Data integrity cannot be guaranteed - this procedure is not recommended for production systems. 

1) update sysdatabases set status=-32768, status2=0 where name='suspect_database' 
2) shutdown with nowait 
3) restart dataserver 
4) dump tran suspect_database with no_log 
5) update sysdatabases set status=12, status2=0 where name='suspect_database' 
6) recycle dataserver
Retrieved from "http://petersap.nl/SybaseWiki/index.php?title=Corruption_of_Syslogs_(log_suicide)&oldid=1869"