New answers tagged maintenance
0
The various options are all well documented here, including a decision matrix to help you decide.
2
You should not have your backup files on the SQL server as you would lose those backup if ever there is an issue with the SQL server.
Best practice would be to store your backup outside of the SQL Server (on a shared folder for example) that can be accessed by both node of the AG.
As the primary node can switch from one or the other node, you should code ...
Top 50 recent answers are included
