Difference between revisions of "Corruption of Syslogs (log suicide)"
From SybaseWiki
m |
(No difference)
|
Latest revision as of 14:03, 30 March 2009
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