How to make standby server operational

I did a log-shipping test. Here is the scenario
1. At 5:00PM, a log is backed up on primary server
2. At 5:01PM, the log is copied and restored to standby server in
non-recovery mode
3. At 5:02PM, the primary server is dead completely. No last transaction log
can be created.
My question is: without the last transaction log, how can I turn standby
database in non-recovery mode into operational mode.
Thanksrestore database with recovery
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Peter Zou" <PeterZou@.discussions.microsoft.com> wrote in message
news:15B118D1-AAA6-4C4D-88E4-95A53CA4CB52@.microsoft.com...
>I did a log-shipping test. Here is the scenario
> 1. At 5:00PM, a log is backed up on primary server
> 2. At 5:01PM, the log is copied and restored to standby server in
> non-recovery mode
> 3. At 5:02PM, the primary server is dead completely. No last transaction
> log
> can be created.
> My question is: without the last transaction log, how can I turn standby
> database in non-recovery mode into operational mode.
> Thanks|||restore database [databasename] with recovery
Walter
"Peter Zou" <PeterZou@.discussions.microsoft.com> wrote in message
news:15B118D1-AAA6-4C4D-88E4-95A53CA4CB52@.microsoft.com...
>I did a log-shipping test. Here is the scenario
> 1. At 5:00PM, a log is backed up on primary server
> 2. At 5:01PM, the log is copied and restored to standby server in
> non-recovery mode
> 3. At 5:02PM, the primary server is dead completely. No last transaction
> log
> can be created.
> My question is: without the last transaction log, how can I turn standby
> database in non-recovery mode into operational mode.
> Thanks