How to change default databse backup location in SQL Server

We all are aware of backup in SQL Server and how important it is. But very few have paid attention at backup location. When we take backup SQL Server show folder which is assigned for default backup.
But as its in C drive , almost majority will change location while taking backup.
So its better if we change default backup location to new address.



Its little tricky but simple here
I am using SQL 2012 here

Right click on ServerName in SSMs
Then click on Facets

 Now here we can see the default backup location
Change its with your desired one , its simple :-)





No comments:

Post a Comment

Amazon Contextual Product Ads

Popular Posts