01-08-2013 12:28 AM
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.
Solved! Go to Solution.
01-08-2013 12:45 AM
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.
01-08-2013 12:42 AM
Backup Exec Service Account should have full Administrator rights & permission on SQL.
01-08-2013 12:42 AM
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!
01-08-2013 12:45 AM
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.
01-08-2013 12:50 AM
Correct, see the statement of Symantec on this page:
http://www.symantec.com/business/support/index?page=content&id=TECH56694
The SQL service pack level while restoring system databases (i.e., Master, Model and Pub databases) must be the same as that of the SQL service pack level of the SQL Instance that was backed up or the restore job will fail.
01-08-2013 01:03 AM
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.
01-08-2013 01:22 AM
My mistake... I use Backup Exec 2010 R3 SP2.
01-08-2013 01:29 AM
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.
01-08-2013 01:36 AM
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.
01-08-2013 02:09 AM
01-08-2013 02:20 AM
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.
01-08-2013 02:39 AM
If you want to copy the logins from the old server to the new server, check this Microsoft KB: