How to change the default backup location in MS SQL 2016?

Changing the default backup location in MS SQL 2016 is very easy!

After default installation of new SQL Server 2016 the directory for BackUp files can be found here:

"C:\Program Files\Microsoft SQL Server\MSSQL13.ADS\MSSQL\Backup"

There are two ways have to change the location for backup file ( . BAK )

1) Using Management Studio

a) Open Management Studio, right click on Instance and click Properties

Properties of Instance

b) In the left panel choose "Database Settings" and then in Sections "Database default Locations" there you can change location for BackUp.

Server Properties

Locate Folder

c) In the end click on OK and we are done!

- OR -

2) Using Registry via Query

Have a nice day!

RECENT POST