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

[Tom]

Hi
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
Server\Dane\MSSQL\Data\master.mdf',
MOVE 'mastlog' TO 'C:\Program Files\Microsoft SQL
Server\Dane\MSSQL\Data\mastlog.ldf',
REPLACE
go


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?

 

[Sylvain Lafontaine]

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:

http://support.microsoft.com/kb/224071
http://www.databasejournal.com/features/mssql/article.php/3379901