SQLTeam.com | Weblogs | Forums

SQL automated backup

Hi, we have a SQL database for our shop which is over 5gb we are constantly getting bookings throughout the day and trying to find the best way to keep a backup on another server incase it is hacked. I don’t want to clone incase it gets hacked and something malicious is inserted into the database. I’d rather have a back up made into a zip and then automatically transferred onto the cloud or another destination. We have a dedicated windows server and the hosting company offers a backup from the day before but that is no use to us. Can anybody recommend a solution. I am in fear of ransomware and also being hacked.

Welcome

You can use the backup feature of sql server out of the box and point it to save to your desired destination

That is one option

Can you point it to another server?

Yes as long as it is a folder the sql service account has permission to.