Friday, March 23, 2012

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
>
>

No comments:

Post a Comment