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

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: "Tom" <no_mail@xxxxxx>
Date: Tue, 22 Apr 2021 12:09:33 +0200

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?

.

Follow-Ups:
- Re: MSSQL Restore Error: The system database cannot be moved by RESTORE
  - From: Sylvain Lafontaine

Prev by Date: Re: Using an unbound form for displaying and updating data
Next by Date: LINKING TO AN SQL SERVER 2005 DB THROUGH ACCESS 2007
Previous by thread: Modifying Table through Access in different Schema on SQL 2005
Next by thread: Re: MSSQL Restore Error: The system database cannot be moved by RESTORE
Index(es):
- Date
- Thread

Relevant Pages

Re: RESTORE WITH REPLACE
... ALTER DATABASE Juris5591000 SET SINGLE_USER ... RESTORE DATABASE JBills5591000 ... WITH MOVE 'Juris9999002_log' TO 'C:\Program Files\Microsoft SQL ...
(microsoft.public.sqlserver.programming)
Re: database problem
... BACKUP DATABASE db TO DISK = '' WITH INIT ... RESTORE DATABASE db FROM DISK = '' ... Links for SQL Server Books Online: ...
(comp.databases.ms-sqlserver)
RE: RESTORE WITH REPLACE
... RESTORE DATABASE Juris5591000 ... WITH MOVE 'Juris9999002' TO 'C:\Program Files\Microsoft SQL ... > RESTORE DATABASE Juris5591000 ... > syntax error any place I try to insert it into the procedure. ...
(microsoft.public.sqlserver.programming)
Re: how to move large online database
... But when I will restore database from backup this will take sql and computer ... Note that this will be at the same server where the old database runs ... ...
(microsoft.public.sqlserver.server)
Fixed
... I also found this article that gives the proper way to move system dbs in sql 2008: ... The model exists where the master states it exists. ... This is the error log prior to detaching the model database. ...
(microsoft.public.sqlserver.server)