db stuck on loaded status

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.
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 the 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?
>
>