I want to know how the failover database concept works after recovery. We have defined our application to connect to a backup database in case the production database fails. If this happens, then all ...
If we have a situation where SQL Agent fails to start, will we still be able to take a full manual SQL backup? I don't mean scheduled backups and maintenance plans, just plain Right Click > Tasks > ...