View source for Corruption of Syslogs (log suicide)

== Log Suicide ==
----
'''Note: Data integrity cannot be guaranteed - this procedure is not recommended for production systems.'''
----
<pre>
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 
</pre>
[[Category:ASE]]