DB in "loading" state - error 22274

We had a situation where we had to restore one of our SQL
databases to the same server the original was running on.
We restored using Arcserve 2000 w/ SQL Agent and it
completed successfully to a different name & directory.
Name of DB was RES_LAW & we had the .mdf & .ldf files
named differently then the originals and in a different
folder.
Arcserve finished the restore successfully with no errors.
When you go into Enterprise Manager the database is there
but shows up GRAY and says "loading" underneath it. When
you double-click to expand properties, you get two errors:
1. error 22274 [SQL-DMO]This Database has been marked
inaccessible (then when you click OK, you get...)
2. Could not get property information for the
database "res_law"
Then it closes.
Does anyone know what is wrong or what we should do?
Computer Associates (maker of Arcserve, said it's not
their problem)
Any help is greatly appreciated.It may just need to be recovered. From Query Analyzer,
execute the following:
RESTORE DATABASE yourDB WITH RECOVERY

quote:

---

>Does anyone know what is wrong or what we should do?
>Computer Associates (maker of Arcserve, said it's not
>their problem)

---

Sounds familiar and you have my sympathy.
Linchi

quote:

---

>--Original Message--
>We had a situation where we had to restore one of our SQL
>databases to the same server the original was running

---

on.

quote:

---

>We restored using Arcserve 2000 w/ SQL Agent and it
>completed successfully to a different name & directory.
>Name of DB was RES_LAW & we had the .mdf & .ldf files
>named differently then the originals and in a different
>folder.
>Arcserve finished the restore successfully with no errors.
>When you go into Enterprise Manager the database is there
>but shows up GRAY and says "loading" underneath it. When
>you double-click to expand properties, you get two errors:
>1. error 22274 [SQL-DMO]This Database has been marked
>inaccessible (then when you click OK, you get...)
>2. Could not get property information for the
>database "res_law"
>Then it closes.
>Does anyone know what is wrong or what we should do?
>Computer Associates (maker of Arcserve, said it's not
>their problem)
>Any help is greatly appreciated.
>
>.
>

---