db in loading status after restore

[lisa]

I performed a database restore this morning from a backup that I had
created yesterday - the database was backed up to a file, not a backup
device.

After the restore completed, the database was left in a LOADING status. I
checked the log and it stated 'Bypassing recovery for database X because
it is marked in load. I used the enterprise tools (all tasks/restore
database) to do the restore.

I asked one of our senior dba's for help, and he followed the same process
I did and it worked fine for him.

Any idea why my database was left in a loading status? The database was
fine prior to the restore.

[Jun]

Watch him step by step when he is doing the restore next time. Pay special attentions to the options he specifies.


------------
lisa at 4/10/2002 11:04:16 AM

I performed a database restore this morning from a backup that I had
created yesterday - the database was backed up to a file, not a backup
device.

After the restore completed, the database was left in a LOADING status. I
checked the log and it stated 'Bypassing recovery for database X because
it is marked in load. I used the enterprise tools (all tasks/restore
database) to do the restore.

I asked one of our senior dba's for help, and he followed the same process
I did and it worked fine for him.

Any idea why my database was left in a loading status? The database was
fine prior to the restore.