cancel
Showing results for 
Search instead for 
Did you mean: 

Master Database restore

PeterGust
Level 4

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
 
 

 

1 ACCEPTED SOLUTION

Accepted Solutions

pkh
Moderator
Moderator
   VIP    Certified

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.

View solution in original post

11 REPLIES 11

ZeRoC00L
Level 6
Partner Accredited

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

CraigV
Moderator
Moderator
Partner    VIP    Accredited

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
Moderator
Moderator
   VIP    Certified

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
Level 6
Partner Accredited

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.

pkh
Moderator
Moderator
   VIP    Certified

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
Level 4

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

 

PeterGust
Level 4

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
Moderator
Moderator
   VIP    Certified

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
Level 4

 

 

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
Moderator
Moderator
   VIP    Certified

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
Level 6
Partner Accredited

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