I have a website that is linked to a database, called Database A. I have set it up to make automatic updates every day. I have set up another server and inside of that server I have created another Database called Database B, and what I want to do is as soon as the backup is created of Database A, I want to sync it up and restore Database B with that backup. This way if my first server goes down, all I have to do is link my website to the second database.
36 freelancers are bidding on average $133 for this job
What you require is a replication service. Or we can write some sql code to restore your database B while you are taking backup of Database A. Let me know if you are interested. Thanks.
Hi sir,I have already created a backup and restore creator in SQL for a client who required same and this worked even on 100gb database size. if you interested, we can chat.