• Grey Twitter Icon
  • Grey Facebook Icon
  • Grey LinkedIn Icon
  • Grey Google+ Icon

© 2016 - 2019 All rights reserved. PigeonSQL.com | Filip Holub

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

December 20, 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

 

 

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

 

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

                      

                       - OR -

 

2) Using Registry via Query

 

 

Have a nice day!

 

 

 

Please reload

RECENT POST
Please reload

  • Facebook Social Icon
  • Google+ Social Icon
  • LinkedIn Social Icon
  • Twitter Social Icon