Picture A
Now if you want to move the files, you will have to remove the current entry and recreate a new entry with the correct path. For example, you will move the Master database table to (C: Test). You will delete -l [path] by selecting the old parameter and selecting remove (Figure B). The next step is to add the following entry (Figure C), -l (c: Testmastlog.ldf) and click OK twice. Then stop SQL Server and move the mastlog.ldf to the new location.
Figure B
Note : Make sure the mastlog.ldf is moved to the location you configured at the boot parameters. If you move the file to an unknown location on the boot parameters, SQL Server will not be activated.
Figure C
If you successfully move the Master database, when you start SQL Server, you will see the following screen:
Figure D
Move Tempdb
To move the tempdb database, open the query analysis tool and run the following query:
use master go
Alter database tempdb modify file (name = tempdev, filename = 'E: Sqldata empdb.mdf')
go
Alter database tempdb modify file (name = templog, filename = 'E: Sqldata emplog.ldf')
Go
Depends on where you move Tempdb which specifies the file name = parameter. You will move the templog to (c: est) as shown in Figure E. After running the query, delete the old file immediately after starting SQL Server.
Figure E
Move MSDB database
To move the MSDB and Model databases, follow these steps. First, right-click on the name of SQL-Server and click Properties . From the General tab, select the boot parameters. Next, enter the parameter -T3608 . Click OK , stop and restart SQL Server. After restarting, remove the database and move them to the appropriate locations.
Hard disk space is getting more crowded and you need to transfer system database files to another drive, following the above procedures will help you transfer data efficiently and reliably.