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 datab...
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.

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.