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

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

How to make a StandBy server to be a Primary server?

Hi,
In the SQL Server 2000 log shipping, how do we make a StandBy server to be a
Primary server?
Thanks for help.
JasonJason
RESTORE db on the standy server ,make sure that it sets to use with
multi-users
"Jason Huang" <JasonHuang8888@.hotmail.com> wrote in message
news:%23aqFkibJIHA.2480@.TK2MSFTNGP05.phx.gbl...
> Hi,
> In the SQL Server 2000 log shipping, how do we make a StandBy server to be
> a Primary server?
> Thanks for help.
>
> Jason
>|||Hi Jason
Do you mean failing over to a secondary or changing roles?
You may want to check out "Changing the Role of a Standby Server" in
http://www.microsoft.com/technet/pr...oy/hasog02.mspx
John
"Jason Huang" wrote:

> Hi,
> In the SQL Server 2000 log shipping, how do we make a StandBy server to be
a
> Primary server?
> Thanks for help.
>
> Jason
>
>

How to make a StandBy server to be a Primary server?

Hi,
In the SQL Server 2000 log shipping, how do we make a StandBy server to be a
Primary server?
Thanks for help.
JasonJason
RESTORE db on the standy server ,make sure that it sets to use with
multi-users
"Jason Huang" <JasonHuang8888@.hotmail.com> wrote in message
news:%23aqFkibJIHA.2480@.TK2MSFTNGP05.phx.gbl...
> Hi,
> In the SQL Server 2000 log shipping, how do we make a StandBy server to be
> a Primary server?
> Thanks for help.
>
> Jason
>|||Hi Jason
Do you mean failing over to a secondary or changing roles?
You may want to check out "Changing the Role of a Standby Server" in
http://www.microsoft.com/technet/prodtechnol/sql/2000/deploy/hasog02.mspx
John
"Jason Huang" wrote:
> Hi,
> In the SQL Server 2000 log shipping, how do we make a StandBy server to be a
> Primary server?
> Thanks for help.
>
> Jason
>
>

How to make a StandBy server to be a Primary server?

Hi,
In the SQL Server 2000 log shipping, how do we make a StandBy server to be a
Primary server?
Thanks for help.
Jason
Jason
RESTORE db on the standy server ,make sure that it sets to use with
multi-users
"Jason Huang" <JasonHuang8888@.hotmail.com> wrote in message
news:%23aqFkibJIHA.2480@.TK2MSFTNGP05.phx.gbl...
> Hi,
> In the SQL Server 2000 log shipping, how do we make a StandBy server to be
> a Primary server?
> Thanks for help.
>
> Jason
>
|||Hi Jason
Do you mean failing over to a secondary or changing roles?
You may want to check out "Changing the Role of a Standby Server" in
http://www.microsoft.com/technet/prodtechnol/sql/2000/deploy/hasog02.mspx
John
"Jason Huang" wrote:

> Hi,
> In the SQL Server 2000 log shipping, how do we make a StandBy server to be a
> Primary server?
> Thanks for help.
>
> Jason
>
>