Standby Server

[Xiaodong Han]

Hi:

Anyone has a detailed procedure description about how to setup a standby
server? Microsoft makes it sounds very easy which are more complicated.
How to handle system databases, does standby server need to be exact
hardware as the primary one?
Thanks in advance,

Xiaodong
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

[Greg D. Moore \(Strider\)]

"Xiaodong Han" <xi*********@hrandassociates.com> wrote in message
news:3f*********************@news.frii.net...

Hi:

Anyone has a detailed procedure description about how to setup a standby
server?
As you say, Microsoft has white papers on it.
Microsoft makes it sounds very easy which are more complicated.
How to handle system databases, does standby server need to be exact
hardware as the primary one?
"It depends"

What do you mean by stand-by?

A clustered server (that requires Enterprise licenses)
A log-shipping server.
A replication driven server
Other?

Each has its plusses and minuses and is set up differently.



Thanks in advance,

Xiaodong
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!