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

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



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?


.



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)