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:

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

--
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
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?



.

Quantcast