Restoring a Database

[benoitt]

Hi, I did a backup of a simple database with only one table... I delete the database and try to restore it.
The restore work fine... But, no table are into the database and when I tried to select my databse from JISQL, I got the error : database is currently offline... I look
throw the documentation to put it back online... But no succes... Can you help me with that...

 

[sybaseguru]

If you have loaded your database properly in ASE with no error use the folowing command to bring it online

use master
go
online database <DATABASE_NAME>
go

hope this helps and good luck

 

[benoitt]

Thanks, it work fine... So, you can close the thread...

 

[sybaseguru]

Sorry I am not the one that closes the case benoitt. Actually you do not need to close the case. Other people may find it useful as well in case they have come across similar problem. You may decide to mark it as helpful if you feel that was the case so others notice

Good luck