var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Help rollback recovery
after a restart during a IQ DELETE FROM ....
it's impossible to performe a USE MYDATABASE
I tried to dump tran ... with truncate_only
but nothing better
the message is
indexspace ... needs rollback recovery
tks a lot and sorry for my english
Is this Sybase IQ or Sybase ASE?
IQ -m on startup would suicide the log, which means data is lost. Not much you can do in IQ if it fails recovery.
Sybase ASE, you can either alter the log in bypass recovery that is update the master.sysdatabases.status = -32768 and then dbcc dbrepair(<db>, remap)
alter database dbname log on dev=<size>
DO NOT issue a SHUTDOWN(you will suicide the log)
alternatively, you can choose to suicide the log. You will lose data
don't run alter database, instead, just issue a checkpoint in the database and do a normal shutdown.
I tried to bypass the recovery but nothing better with dbcc...
In fact I don't wait the time needed by a simple "USE my_indexspace" with sa role...
When I tried it I wait only 1 hour, but it takes finaly 3 hours !!!!
Thks a lot for your reply
PS : Sorry for my English : really poor !!! But I can understand quite more.
Don't be sorry dude. I can't speak your language either, so we are even.