Error 913: Could not find database ID119. Database may not be acti

Hi,
After restore i get this error in MSSQL server 2000 (SP4)
Error 913: Could not find database ID119. Database may not be activated or
may be in transitionw
I can not find out wath could be wrong the only thing that is diffrent in
SYSDatabases i that the version column is NULL all other databases have a
version number 539 the status is 1077936153.
We did not get any error during restore the .bak fil is from an other SQL
server SP4 and the database works there. We have moved databases before
without any problem.
--
Marcin S.When and where you are getting that error?
--
HTH,
Vyas, MVP (SQL Server)
SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
"Marcin S." <MarcinS@.discussions.microsoft.com> wrote in message
news:C8A32931-5D30-4B37-9EF9-68280A564AAC@.microsoft.com...
Hi,
After restore i get this error in MSSQL server 2000 (SP4)
Error 913: Could not find database ID119. Database may not be activated or
may be in transitionw
I can not find out wath could be wrong the only thing that is diffrent in
SYSDatabases i that the version column is NULL all other databases have a
version number 539 the status is 1077936153.
We did not get any error during restore the .bak fil is from an other SQL
server SP4 and the database works there. We have moved databases before
without any problem.
Marcin S.|||I get this error all the time if i try to list tables or when i try to view
propperties, just anywhere when i try to do some thind with this databas.
I can see the database in DB list, it is in the SYSDATABASES but it is
inaccessible
BUT!
When i run : DBCC CHECKDB ('someDB') i then get
Server: Msg 911, Level 16, State 1, Line 1
Could not locate entry in sysdatabases for database 'MSSQL100011'. No entry
found with that name. Make sure that the name is entered correctly.
but a selects in SYSDATABASES says that it exists... strange
And as i wrote i can restore any database that I backup on the serbver but
when moving this from an other Working SQL server. The Restore process is
done successfull without any error.
--
Marcin S.
"Narayana Vyas Kondreddi" wrote:
> When and where you are getting that error?
> --
> HTH,
> Vyas, MVP (SQL Server)
> SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
>
> "Marcin S." <MarcinS@.discussions.microsoft.com> wrote in message
> news:C8A32931-5D30-4B37-9EF9-68280A564AAC@.microsoft.com...
> Hi,
> After restore i get this error in MSSQL server 2000 (SP4)
> Error 913: Could not find database ID119. Database may not be activated or
> may be in transitionw
> I can not find out wath could be wrong the only thing that is diffrent in
> SYSDatabases i that the version column is NULL all other databases have a
> version number 539 the status is 1077936153.
> We did not get any error during restore the .bak fil is from an other SQL
> server SP4 and the database works there. We have moved databases before
> without any problem.
>
> --
> Marcin S.
>
>sql