Forum Discussion

PeterGust's avatar
PeterGust
Level 4
12 years ago

Master Database restore

Hi

I'm trying to restore a SQL 2005 Master Database to a new server and a new SQL version (SQL 2008 R2).

I just end up with this message:

V-79-65323-3201 - An error occurred on a query to database master.

 

V-79-65323-3201 - Cannot open backup device 'master_00__603f0812_cf8d_4e13_a27b_67439aa89114_'. Operating system error 0x80070005(failed to retrieve text for this error. Reason: 15100).
 
I a have tried everything I can think of, like SQL in Single User Mode, RAWS in debug mode.
 
Restore of user databases works fine.
 
 
Backup Exec 2010 R2 SP2
 
//Peter
 
 

 

2012
Backup and Recovery
Backup Exec
Restore
Tip-How to
Troubleshooting
  • pkh's avatar
    pkh
    12 years ago

    If I am not mistaken, you cannot restore a master database from one version of SQL to another.  Why do you want to do this? You just restore your other databases from your applications and the master databases will be populated with their information.

    *EDIT*

    You only restore the master database if it is damaged and you are unable to restore or operate the other databases.  Otherwise, you leave the master database alone.

11 Replies

Sort By
  • ZeRoC00L's avatar
    ZeRoC00L
    Level 6
    12 years ago

    Backup Exec Service Account should have full Administrator rights & permission on SQL.

  • CraigV's avatar
    CraigV
    Moderator
    12 years ago

    Hi Peter,

     

    Check the TN below on how to troubleshoot this error:

    http://www.symantec.com/business/support/index?page=content&id=TECH72460

     

    Furthermore you should look at upgrading to BE 2010 R3 with SP2. The upgrade is free and you can use your same licenses. BE 2010 R3 fixed a number of issues with the previous 2 versions.

    Just grab copies of the Data/Catalogs folders before doing so, and then push-install the RAWS agents again once upgraded, if you so choose.

    Here is the link for the ISO:

    http://trialware.norton.com/files/fc/Backup_Exec_2010_13.0.5204_MultiPlatforms_Multilingual_DVD.iso

    Thanks!

  • pkh's avatar
    pkh
    Moderator
    12 years ago

    If I am not mistaken, you cannot restore a master database from one version of SQL to another.  Why do you want to do this? You just restore your other databases from your applications and the master databases will be populated with their information.

    *EDIT*

    You only restore the master database if it is damaged and you are unable to restore or operate the other databases.  Otherwise, you leave the master database alone.

  • pkh's avatar
    pkh
    Moderator
    12 years ago

    Ah! Thanks for the confirming document.

    Normally, as a rule of thumb, for Microsoft products, you cannot restore system-type files from one version to another.  They like to change the structure so the files would be incompatible from one version to the next.

  • PeterGust's avatar
    PeterGust
    Level 4
    12 years ago

    Move DB to a new hardware and new SQL server. I need to restore master DB to get all SQL logins.
    I have tried to find anything about restoring Master DB between different SQL version.

  • pkh's avatar
    pkh
    Moderator
    12 years ago

    You should have done an in-place upgrade of your existing SQL instance and then port that to the new hardware.  As you can see in the document quoted above, you cannot restore the master database from one version os SQL to another.

  • PeterGust's avatar
    PeterGust
    Level 4
    12 years ago

     

     

    OK, "MASTER Database cannot be redirected on a different server", that's what I was looking for
     
    It is possible to move system databases but it is more of a manual work.
    http://msdn.microsoft.com/en-us/library/ms345408(v=sql.105).aspx
     
    Thanks for all help.
     
    //Peter
  • pkh's avatar
    pkh
    Moderator
    12 years ago

    The document you quoted does not state whether you can use the procedure to move the master database from one version of SQL to another.  I suspect the procedure is not applicable in your case.  If you do succeed in moving your master database from one version of SQL to another, do let us know.