cancel
Showing results for 
Search instead for 
Did you mean: 

Netbackup not showing SQL primary mirror backups in restore list

Danielle2
Level 2


We recently noticed backups made of primary mirror pair databases (not secondary) which show in the client status as having been successfully backed up are not enumerated in the list of databases available for restore using a client restore from the same server. Effectively this means our databases are not backed up as they are currently unavailable for restore.

Has anyone else noticed this behaviour?

Screenshots showing successful backup of a db named ADBC_OTEN then the database not being enumerated for restore are attached below. This seems to be occuring across all our mirror primaries on SQL2008R2 except a few on SQL2012 - the environment is large and we are still checking but I wanted to get this out there to see if anyone has a quick answer.

Netbackup server view shows the primary mirrors are in the catalogue/contents list for the server meaning they were backed up, as shown in the last screengrab.

TIA,   Danielle.

principal.png

backup_mirror.png

 

restore_criteria.png

restore_enumeration.png

 

server_enumeration.png

Excuse me if this is vague, this is my first question on this topic and we are the database administrators not the primary backup admins.

The mirror dbs are in yellow.

1 ACCEPTED SOLUTION

Accepted Solutions

watsons
Level 6

Have you checked out the NBU admin guide for MSSQL? 

http://www.symantec.com/docs/DOC6479

In page 152~153, it stated that you need to create the a file (No.Restrictions) in master server, this is usually needed for restore & browse to work properly. That file is not required for a successful backup. To create that file, contact your Netbackup admin.

View solution in original post

3 REPLIES 3

RiaanBadenhorst
Moderator
Moderator
Partner    VIP    Accredited Certified

Have you checked the same from the other server (mirrored one)? It might have moved.

Danielle2
Level 2

Yes, that the mirror was still the primary was checked - and shows in the first picture as well (Principal, Synchronised)

watsons
Level 6

Have you checked out the NBU admin guide for MSSQL? 

http://www.symantec.com/docs/DOC6479

In page 152~153, it stated that you need to create the a file (No.Restrictions) in master server, this is usually needed for restore & browse to work properly. That file is not required for a successful backup. To create that file, contact your Netbackup admin.