Backup for our SQL windows 2003 server in case of failure

We have a SQL 2008 running on our 2003 Windows Server.  Is it possible to have a second server running, backing up this server.

Also, if the first server fails, the second would be ready to replace the second?
al4629740Asked:
Who is Participating?
 
David ToddConnect With a Mentor Senior DBACommented:
Hi,

There are several strategies, depending on distance, time-lag for failover, whether that is automatic or manual.

Mirroring is possibly the easiest to get up and running.
http://msdn.microsoft.com/en-us/library/ms189852.aspx
http://technet.microsoft.com/en-us/library/cc917681.aspx

HTH
  David
0
 
al4629740Author Commented:
It would be at the same location.  How would I begin to see how to set that up?
0
 
David ToddSenior DBACommented:
Hi,

You'll need to look up mirroring in those links.

Basically there is a principal, a mirror, and optionally a witness server.

Seems ideal where there is good response and throughput between the two severs.

SQL 2012 has availability groups, where there can be multiple mirrors ...

HTH
  David

PS Test FIRST
0
All Courses

From novice to tech pro — start learning today.