Error restoring database

I'm trying to restore a database and getting the following error:
Bypassing recovery for database 'SPS02_Config_db' because it is marked IN
LOAD.
It's been sitting in this state for about 30 minutes now, and I don't know
what to do. This is the main config database for our sharepoint install. I
really need some help.
TIA,
JerameHi,
There are 2 chances for this error:-
1. Restored the database with NORECOVERY
2. Restore staopped in middle.
If the problem is because of second issue then you need to restore the
database from a backup.
If the problem is because of first issue then issue the below command to
make the database online.
RESTORE DATABASE <DBNAME> WITH RECOVERY
Thanks
Hari
SQL Server MVP
"Jerame" <Jerame@.discussions.microsoft.com> wrote in message
news:79D5AB18-1D56-448B-A791-80D7CFF90445@.microsoft.com...
> I'm trying to restore a database and getting the following error:
> Bypassing recovery for database 'SPS02_Config_db' because it is marked IN
> LOAD.
> It's been sitting in this state for about 30 minutes now, and I don't know
> what to do. This is the main config database for our sharepoint install. I
> really need some help.
> TIA,
> Jerame|||Thanks for the response!
I reran the restore, and it worked that time.
"Hari Prasad" wrote:
> Hi,
> There are 2 chances for this error:-
> 1. Restored the database with NORECOVERY
> 2. Restore staopped in middle.
> If the problem is because of second issue then you need to restore the
> database from a backup.
> If the problem is because of first issue then issue the below command to
> make the database online.
> RESTORE DATABASE <DBNAME> WITH RECOVERY
> Thanks
> Hari
> SQL Server MVP
> "Jerame" <Jerame@.discussions.microsoft.com> wrote in message
> news:79D5AB18-1D56-448B-A791-80D7CFF90445@.microsoft.com...
> > I'm trying to restore a database and getting the following error:
> >
> > Bypassing recovery for database 'SPS02_Config_db' because it is marked IN
> > LOAD.
> >
> > It's been sitting in this state for about 30 minutes now, and I don't know
> > what to do. This is the main config database for our sharepoint install. I
> > really need some help.
> >
> > TIA,
> > Jerame
>
>