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 location is in the C: Drive; when trying to restore using MOVE:
RESTORE DATABASE master FROM DISK ='\\Pfileserver\sqlbackup\MDFfiles\master_db_20070 8170121.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,
Carloshttp://support.microsoft.com/kb/224071/EN-US/
Please let know whether this info is useful.
thanks
Showing posts with label previous. Show all posts
Showing posts with label previous. Show all posts
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
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
Subscribe to:
Posts (Atom)