db stuck on loaded status

I restored a full backup, then each of the logs, after the final log I perfo
rmed a restore with standby option to make Read-Only, yet accessible.
Problem, database stuck in loaded status, all my logs were restored properly
. How do I change status to Read-Only from Loaded?
Thanks.Hi,
Ir seems the last transaction log was restored with NORECOVERY option. Can
you issue the below command to open the database in standby mode.
restore database <dbname> with STANDBY = 'c:\undo.ldf'
After that try to access the database.
Thanks
Hari
MCDBA
"Chris" <Chris@.discussions.microsoft.com> wrote in message
news:B17DAE52-973F-4C8E-8118-261AE8131D71@.microsoft.com...
> I restored a full backup, then each of the logs, after the final log I
performed a restore with standby option to make Read-Only, yet accessible.
> Problem, database stuck in loaded status, all my logs were restored
properly. How do I change status to Read-Only from Loaded?
> Thanks.|||I had a feeling that's what happened. So I created another log backup form t
he source db and double/triple checked my syntax... problem solved.
Thanks.
"Hari Prasad" wrote:

> Hi,
> Ir seems the last transaction log was restored with NORECOVERY option. Can
> you issue the below command to open the database in standby mode.
> restore database <dbname> with STANDBY = 'c:\undo.ldf'
> After that try to access the database.
> Thanks
> Hari
> MCDBA
>
> "Chris" <Chris@.discussions.microsoft.com> wrote in message
> news:B17DAE52-973F-4C8E-8118-261AE8131D71@.microsoft.com...
> performed a restore with standby option to make Read-Only, yet accessible.
> properly. How do I change status to Read-Only from Loaded?
>
>