mardi 3 février 2015

Keeping an up to date copy of a SQL Server database on another server


We outsourced some of our business functions to another company. That company makes use of the same software as we do and we would like to keep a update to date copy of their database on our servers for monitoring purposes.


Just to clarify what I mean by having an an update to date copy we don't mind if the database is only updated or synchronized once a day.


Last thing to keep in mind is that the connection between the companies is a 10 Mbps connection.


We are both running Microsoft SQL Server 2008 R2 (SP2) - 10.50.4000.0 (X64).


How would you tackle this?





Aucun commentaire:

Enregistrer un commentaire