Making backup from database to another server

58 views Asked by At

I have a host on a server and that contains an SQL Server Database. I have another server in another country and i want have a backup from the database every 5 minutes or after each transaction only insert new row to another database. After some research i found out i can use linkedservers for this goal. Is this procedure works for me for doing this operation?

1

There are 1 answers

1
Mathese F On

I don't know what the linkedserver will do for you.

You are connected from both server via a vpn? You are in different network (domain) probably?

If you are using a linked server, it means you will probably create trigger or stored proc. You will have to configure msdtc (for trigger).

You can use :

  • Replication
  • Log shipping
  • Custom replication process

I had to configure 2 times a replications to move the data from a server to another, than manage these data with trigger. It was easier to work on the data localy