System and user Databases Location Moving

Steps  to Move System DBs after installing SQL Server
1. Take Full Backups for all Databases
2.Stop SQL Services
3.
a.
Create  folders  named “System data and logs” in G Drive, “TempDB” in T Drive , “Data_File” in H drive, “Log_File” in L  Drive.

Folder Name	Drive
System data and logs	G
TempDB	T
Data_File	H
Log_File	L

Copy files as below

File Name	Source	Target/Destination
master.mdf	C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA	G:\System Data and Logs
master.ldf	C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA	G:\System data and logs
Log\ERRORLOG	C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\Log\ERRORLOG	G:\System data and logs
model.mdf	C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA	G:\System data and logs
model.mdf	C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA	G:\System data and logs
MSDBData.mdf	C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA	G:\System data and logs
MSDBData.ldf	C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA	G:\System data and logs
tempdb.mdf	C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA	T:\TempDB
templog.ldf	C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA	T:\TempDB
ReportServer.mdf	C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA	H:\Data_File
ReportServer_log.ldf	C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA	L:\Log_File
testdb.mdf	C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA	H:\Data_File
testdb.ldf	C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA	L:\Log_File

 Change Default Database Path

 4. Moving Master Database and Log\ERRORLOG

Change in Startup Parameter for moving master Database and and Log\ERRORLOG
Current Startup Parameter:
-dC:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\master.mdf;-eC:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\Log\ERRORLOG;-lC:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\mastlog.ldf

 New Path in Startup Parameter:

-dG:\ System data and logs\master.mdf;-eG:\ System data and logs\Log\ERRORLOG;-lG:\ System data and logs\mastlog.ldf

5. Start services and Verify master database location

SELECT name, physical_name FROM sys.master_files
WHERE database_id = DB_ID('master');

6.change destination path and  Run below script to move msdb and model databases

a. Moving  MSDB DB
Run below Script :
Use master
Go
Alter Database MSDB
Modify File (Name = 'MSDBData', FileName = 'G:\System Data ang Logs\MSDBData.mdf')
Go
Use master
Go
Alter Database MSDB
Modify File (Name = 'MSDBLog', FileName = 'G:\System Data ang Logs\MSDBData.ldf')
Go
b. Moving  Model
Run below Script :
Use master
Go
Alter Database model
Modify File (Name = 'modeldev', FileName = 'G:\System Data ang Logs\model.mdf')
Go
Use master
Go
Alter Database model
Modify File (Name = 'modellog', FileName = 'G:\System Data ang Logs\modellog.ldf')
Go
c. Moving  Tempdb
Run below Script :
Use master
Go
Alter Database tempdb
Modify File (Name = 'tempdev', FileName = 'T:\TempDB\tempdb.mdf')
Go
Use master
Go
Alter Database tempdb
Modify File (Name = 'templog', FileName = 'T:\TempDB\templog.ldf')

Go

D. Moving  ReportServer 
Run below Script :
Use master
Go
Alter Database ReportServer
Modify File (Name = 'ReportServer', FileName = 'H:\Data_File\ReportServer.mdf')
Go
Use master
Go
Alter Database ReportServer
Modify File (Name = 'ReportServer_log', FileName = 'L:\Data_File\ReportServer_log.mdf')
Go
F. Moving  ReportServerTempDB
Run below Script :
Use master
Go
Alter Database ReportServerTempDB
Modify File (Name = 'ReportServerTempDB', FileName = 'E:\Data_File\ReportServerTempDB.mdf')
Go
Use master
Go
Alter Database ReportServerTempDB
Modify File (Name = 'ReportServerTempDB_log', FileName = 'E:\Data_File\ReportServerTempDB_log.mdf')
Go
G. Moving  testdb
Run below Script :
Use master
Go
Alter Database ptc
Modify File (Name = 'testdb_data', FileName = 'E:\Data_File\testdb.mdf')
Go
Use master
Go
Alter Database ptc
Modify File (Name = 'testdb_log', FileName = 'E:\Data_File\test.mdf')
Go
7.Stop Services
8.Start services and Verify
SELECT name, physical_name
FROM sys.master_files

9.Remove old mdf and ldf files for system databases

-----------------Change Default Backup Path--------

1. Run > REGEDIT

2. HKEY_LOCAL_MACHINE  >  SOFTWARE  > Microsoft > Microsoft SQL Server  > MSSQL10_50.MSSQLSERVER(For Default Instance) > MSSQLServer > BackupDirectory> Modify > OK > Verify From SQL SERVER