Trying to recover database - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Administration (2000)

Trying to recover database

Author

Topic

Rootman
Starting Member

15 Posts

Posted - 2003-05-22 : 00:11:02

I am trying to recover a database, but it seems to be taking forever.

In the SQLlog it says

Bypassing recovery for database 'PORTRAIT_DATABASE' because it is marked IN LOAD.

IS this signinficant?

harshal_in
Aged Yak Warrior

633 Posts

Posted - 2003-05-22 : 07:05:28

quote:

I am trying to recover a database, but it seems to be taking forever.

In the SQLlog it says

Bypassing recovery for database 'PORTRAIT_DATABASE' because it is marked IN LOAD.

IS this signinficant?

LOAD statement is present only for back compatibility if u r using sql 2000
it is similar to restore.
the significance of load is that the database is being restored.
chech the logs what is actually happening.

Expect the UnExpected

izaltsman
A custom title

1139 Posts

Posted - 2003-05-22 : 14:12:07

quote:

I am trying to recover a database, but it seems to be taking forever.
In the SQLlog it says
Bypassing recovery for database 'PORTRAIT_DATABASE' because it is marked IN LOAD.
IS this signinficant?

You have to give us more detail on what exactly you are trying to do and how you are doing it. I am guessing that you just ran RESTORE DATABASE or RESTORE LOG command with NO RECOVERY option. In this case your errorlog indeed will indicate that the database is marked IN LOAD. This means that you can apply additional transaction logs to the database. Once you restored all of your transaction logs, you can use WITH RECOVERY option of the RESTORE statemeent to bring the database online.

RESTORE DATABASE yourdb WITH RECOVERY

Edited by - izaltsman on 05/22/2003 14:16:39

chadmat
The Chadinator

1974 Posts

Posted - 2003-05-22 : 14:32:59

Did you restart SQL Server while the restore was happening?

-Chad

http://www.clrsoft.com

Software built for the Common Language Runtime.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources