Home > IT Answers > Storage > SQL Server 2005 backup server
NewnanIT
1,110 pts.
 SQL Server 2005 backup server
Backup, Backup and Recovery Hardware, SQL 2005, SQL Backup, SQL Server 2005, SQL Server database
Is there a way to replicate a SQL server database to another SQL server with the same hardware and software? I want a live copy of the data up to date in case something goes wrong and we need to switch to the backup server.

Software/Hardware used:
ASKED: September 15, 2010  8:08 PM
UPDATED: January 30, 2012  8:22 AM
RELATED QUESTIONS
Answer Wiki:
Yes. You should be looking at database mirroring. It is a native feature of SQL Server 2005 and higher and will keep an exact duplicate of the database on the second server. =========== It is possible to replicated and SQL server to another by using a third party software. However, you have to research for the best software to do that because most software used for backup are expensive. Just choose the best and suits your budget.
Last Wiki Answer Submitted:  January 30, 2012  8:22 am  by  Denny Cherry   64,520 pts.
All Answer Wiki Contributors:  Denny Cherry   64,520 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _