Note 1611715 - SYB: How to restore a Sybase ASE database server (Windows)

[Former Member]

Hello colleagues.

In continuation of my test recovery in accordance with the note 1611715 step

Re-create and load the job scheduler database 'sybmgmtdb'

You first have to drop the 'sybmgmtdb' database from the catalog of the loaded master database and drop the non-existing sybmgmt database device 'sybmgmtdev'

after the operation

1> drop database sybmgmtdb

2> go

I get the error

Msg 3702, Level 16, State 4:

Server 'TST', Line 1:

Cannot drop the database 'sybmgmtdb' because it is currently in use.

[sap_mk · Accepted solution]

Hi Stepan,

Since you had just restarted the ASE (according to the Note), is it possible that the Job Scheduler task is running?

You can use sp_who to see if any JS tasks are running. Alternatively, you can use the following SELECT statement to see which spids are "in" the database.

select spid from master..sysprocesses where dbid=db_id('sybmgmtdb')

Regards,

Mark Kusma

[Former Member · Accepted solution]

Hi, Mark.

Thanks for the help, I performed sp_who and saw that the base is not used by anyone sybmgmtdb and no processes jtask. I tried again to remove the base and I did. But before that service was restarted Sybase probably the last time was the jtask job.

[former_member188883]

Hi Stepan,

Have to started ASE as service or execute the batch file RUN_<DBSID>.bat ?

Regards,

Deepak Kori

[Former Member]

ASE is running as a service.