Re: MSSQL Restore Error: The system database cannot be moved by RESTORE

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

You cannot simply move the master database files to another location by
simply using the restore command. Follow these instructions if you want to
move the master database:

Sylvain Lafontaine, ing.
MVP - Technologies Virtual-PC
E-mail: sylvain aei ca (fill the blanks, no spam please)

"Tom" <no_mail@xxxxxx> wrote in message mahref="@xxxxxxxxxxxxxxxxxx">news:fukdgu$2ma$1@xxxxxxxxxxxxxxxxxx
I have these parameters:

R:\Backup\master.bak - (Full backup master database)
C:\Program Files\Microsoft SQL Server\Dane\MSSQL\Data\master.mdf -
destination file master database
C:\Program Files\Microsoft SQL Server\Dane\MSSQL\Data\mastlog.ldf -
destination file master log file

After my restrore Transact-SQL query:

RESTORE DATABASE master FROM disk ='R:\Backup\master.bak'
WITH MOVE 'master' TO 'C:\Program Files\Microsoft SQL
MOVE 'mastlog' TO 'C:\Program Files\Microsoft SQL

I have error:

Server: Msg 3179, Level 16, State 1, Line 1
The system database cannot be moved by RESTORE.
Server: Msg 3013, Level 16, State 1, Line 1
RESTORE DATABASE is terminating abnormally.

What is these?