How to change default backup location after installing SQLServer 2008/R2/2012?
Changing default locations of Data and Log file is simple, connect to SQL instance through SSMS and go to properties of the instanceà Database Settings àunder Database Default Locationsà type the desired locations.
But if you want to change the default backup location after installation you need to connect to SQL instance through SSMS and go to properties of the instanceàFacets à Select Server Facets from the drop down list and click on BackupDirectory -à type the desired location.
You can also change the data & log file locations through facets
No comments:
Post a Comment