How to change the default location of datafile logfile and backup file in SQL SERVER

It is very common mistake when we forget to change the default datafile logfile and backup location while installing SQL Server. Below the step you can follow to change the default file location properties.

1. Open the management studio
2. Connect to SQL Server instance
3. Right click on instance and select properties
4. You will get a dialog box. Select “Database Settings” from left pan.
5. Change the new datafile logfile and backup file location in respective text box. Below is on screen shot