Tag Archives: code

How to change the Sql Server backup folder

Scenario proposal
When you install SQL Server the path for the installation is generally something such as the following: C:\Program Files\Microsoft SQL Server\MSSQL.2\MSSQL.

In this directory there are also folders for your DATA files and also your BACKUP files.  Within SQL Server Management Studio you have the ability to change the default location for your Data and Log files for all new databases, but you can not change the default directory for your backups.

Is it possible to change the default directory for backups, so it does not need to be specified each time I run a backup?

Continue reading How to change the Sql Server backup folder