I'm trying to configure azure sql database backup to my local server in weekly basis. This backup will be automatically. even its fine its possible togenerate database script through c# code. There have any tools or c# code that I can create schedule task to take back in weekly or daily interval ?
Thanks in advance!
You should use the Azure feature for the automated backups.
If you setup using the azure webapp, be aware that you can find the backups option at the server (and not at the database) level.
For the retention policies and the frequencies you can look into the Microsoft documentation which is well written.