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

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!

RECENT POST
  • Grey Twitter Icon
  • Grey Facebook Icon
  • Grey LinkedIn Icon

© 2020 All rights reserved. PigeonSQL.com | Filip Holub

  • Twitter Social Icon
  • Facebook Social Icon
  • LinkedIn Social Icon