Set up a SQL Server disaster recovery site |
 |
EXPERT RESPONSE FROM: Eric Johnson
|
|
|
|
| > |
QUESTION POSED ON: 17 October 2007
We have two SQL Server 2000 servers set up for enabling clustering and there is a SAN attached. We want to set up a disaster recovery site away from the above primary site. Can we set up the disaster site with just one database server or do we need to replicate the same primary site setup? How do we set up log shipping?
|
|
| > |
EXPERT RESPONSE
In general, the answer is no. You can set up failover in several ways, be it replication, log shipping, database mirroring, or a third party tool. These are all database specific solutions that do not require the secondary hardware to be the same as the primary hardware. You can run your primary on a cluster and an offsite backup on a standalone SQL Server.
| Check out this helpful podcast: |
|
Log shipping in SQL Server: Basics to best practices
SQL Server database administrator Eric Johnson explains how to back up your primary database and restore it to a secondary server through log shipping. He'll explain log shipping setup via SQL Server Management Studio. Get the details on how to set up multiple log shipping failover boxes to provide High Availability and a reliable reporting environment.
|
|
|
|
|
|
|
|
|
Search and Browse the Expert Answer Center
Search and browse more than 25,000 question and
answer pairs from more than 250 TechTarget industry experts.
|
|
|
|
|
|
|
|
|
|
|
|
