Recovery Query

microsoft.public.sqlserver.programming

24 Aug 2006 2:56 PM

FARRUKH

this morning i tried to recover my database. When recovery done, i checked my
database on Enterprise it says database [Ocean(loading)]. Thts my errorlog
message
SQL Server is ready for client connections
2006-08-24 10:39:55.14 spid8     Starting up database 'msdb'.
2006-08-24 10:39:56.76 spid9     Starting up database 'pubs'.
2006-08-24 10:39:56.81 spid10    Starting up database 'Northwind'.
2006-08-24 10:39:56.81 spid11    Starting up database 'Ocean'.
2006-08-24 10:39:56.87 spid11    Bypassing recovery for database 'Ocean'
because it is marked IN LOAD.

anyone has a solution? i am using sql server 2000.

Farrukh