Video Screencast Help
Symantec to Separate Into Two Focused, Industry-Leading Technology Companies. Learn more.

Master Database restore

Created: 08 Jan 2013 | 11 comments

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
 
 

Comments 11 CommentsJump to latest comment

ZeRoC00L's picture

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

If this response answers your concern, please mark it as a "solution"

CraigV's picture

Hi Peter,

Check the TN below on how to troubleshoot this error:

http://www.symantec.com/business/support/index?pag...

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

Thanks!

Alternative ways to access Backup Exec Technical Support:

https://www-secure.symantec.com/connect/blogs/alte...

PeterGust's picture

My mistake... I use Backup Exec 2010 R3 SP2.

pkh's picture

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.

ZeRoC00L's picture

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.

If this response answers your concern, please mark it as a "solution"

pkh's picture

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 picture

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 picture

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 picture
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 picture

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.

ZeRoC00L's picture

If you want to copy the logins from the old server to the new server, check this Microsoft KB:

http://support.microsoft.com/kb/918992

If this response answers your concern, please mark it as a "solution"