I'm looking for a program that can be scheduled(weekly) to back up a SQL database on a server and download it to my local machine, does anyone have any suggestions?
Thanks
EDIT: i should have specified that the SQL database is on a remote server. I'm looking for a program that will connect, then backup to .sql, then download to my local windows machine.