Backup Scenarios? Which is better? | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Backup Scenarios? Which is better?

Right now our company is contemplating on a bu scenario for our sql servers. Our design is going to have one production server and 2 bu at different locations. The 2 scenarios they are contemplating are:
1. Have the production server update both bu’s directly
2. Have the production update the 1st bu then the 1st bu updates the 2nd. Which is better? Is the second scenario even possible? Any help would be greatly appreciated!!!!!
I would suggest a form of log shipping where you log shipped two one server first, then to the second server second. You would have to write you own log shipping scripts, but that is not hard. ——————
Brad M. McGehee
Webmaster
SQL-Server-Performance.Com
]]>