For SQL Server 2012 and above, is a restart of SQL Server actually required after changing the default backup location? I know it isn't required for the change to take effect but I am worried it will revert without a restart or something similar.
Answer by Magnus Ahlkvist ·
It's an easy thing to test. Just login to a test server, change default backup location and run a backup of a database with
BACKUP DATABASE master TO disk='mastertestbackup.bak' WITH COPY_ONLY
I just did, and it takes effect immediately without a service restart.
Oh, and don't run the backup command without COPY_ONLY, that will break the backup-chain should you need to restore the database later on, as this falls outside of your normal backup routine.