Tuesday, March 20, 2012

Restoring master to a different location

I am trying to restore master to a new server but location of data and log
files is different in this new server. The previous location was 'D:\Program
Files\Microsoft SQL Server\MSSQL\data\" the current is in the C: Drive when
trying to restore using MOVE:
RESTORE DATABASE master FROM DISK
='\\Pfileserver\sqlbackup\MDFfiles\master_db_200708170121.BAK' WITH RECOVERY ,
MOVE 'master' TO 'C:\Program Files\Microsoft SQL
Server\data\master.mdf',
MOVE 'mastlog' TO 'C:\Program Files\Microsoft SQL
Server\MSSQL\data\mastlog.ldf'
I get the following error message:
The system database cannot be moved by RESTORE
Is there a way you can restore master to a different location?
Thanks,
CarlosHi Carlos
http://support.microsoft.com/kb/304692/ describes how to restore a master
database
John
"Carlos" wrote:
> I am trying to restore master to a new server but location of data and log
> files is different in this new server. The previous location was 'D:\Program
> Files\Microsoft SQL Server\MSSQL\data\" the current is in the C: Drive when
> trying to restore using MOVE:
> RESTORE DATABASE master FROM DISK
> ='\\Pfileserver\sqlbackup\MDFfiles\master_db_200708170121.BAK' WITH RECOVERY ,
> MOVE 'master' TO 'C:\Program Files\Microsoft SQL
> Server\data\master.mdf',
> MOVE 'mastlog' TO 'C:\Program Files\Microsoft SQL
> Server\MSSQL\data\mastlog.ldf'
> I get the following error message:
> The system database cannot be moved by RESTORE
> Is there a way you can restore master to a different location?
> Thanks,
> Carlos

No comments:

Post a Comment