Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2002
    Posts
    32

    Unanswered: 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 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,

    Carlos

  2. #2
    Join Date
    Feb 2004
    Location
    Bangalore, India
    Posts
    250
    http://support.microsoft.com/kb/224071/EN-US/


    Please let know whether this info is useful.

    thanks
    Cheers....

    baburajv

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •