Restoring log files

I am testing restoring a database and I am having an issue when I restore
the transacting log file. After the restore, the database is still not
usable (it is marked (restoring...). I use the following command to restore
the log:
RESTORE LOG Databasename FROM
DISK='s:\Databasename_LogBackup_20060926
0805.TRN'
WITH RECOVERY
Is there another step I need to do? If I restore the log using SQL
Management Studio it works fine. I am using SQL 2005.
Thanks,Please ignore. The restore did work fine.
"Tim Kelley" <tkelley@.company.com> wrote in message
news:uevaKsX4GHA.2208@.TK2MSFTNGP04.phx.gbl...
>I am testing restoring a database and I am having an issue when I restore
>the transacting log file. After the restore, the database is still not
>usable (it is marked (restoring...). I use the following command to restore
>the log:
> RESTORE LOG Databasename FROM
> DISK='s:\Databasename_LogBackup_20060926
0805.TRN'
> WITH RECOVERY
>
> Is there another step I need to do? If I restore the log using SQL
> Management Studio it works fine. I am using SQL 2005.
>
> Thanks,
>|||Tim Kelley wrote:
> I am testing restoring a database and I am having an issue when I restore
> the transacting log file. After the restore, the database is still not
> usable (it is marked (restoring...). I use the following command to restor
e
> the log:
> RESTORE LOG Databasename FROM
> DISK='s:\Databasename_LogBackup_20060926
0805.TRN'
> WITH RECOVERY
>
> Is there another step I need to do? If I restore the log using SQL
> Management Studio it works fine. I am using SQL 2005.
>
> Thanks,
>
Did you refresh the "view" in Management Studio? Have you tried
actually connecting to the database to confirm that it's "unusable"?
Tracy McKibben
MCDBA
http://www.realsqlguy.com