cancel
Showing results for 
Search instead for 
Did you mean: 

SQL backup duplication.

Ankit_Maheshwar
Level 5

I want to duplicate my old SQL backup with different retention, is this possible in case of SQL backup?

 

I see under catalog search parent job is not listed for old SQL backup. this can create any hurdle in restore?

Is there any other way to duplicate SQL backup. 

 

1 ACCEPTED SOLUTION

Accepted Solutions

Marianne
Moderator
Moderator
Partner    VIP    Accredited Certified

Parent job is not listed as because no actual data is transferred against the parent job.
Only Child jobs running against the Default Application are transferring data and stored in Image catalog as User Backup with values under 'Files' and 'Kbytes' as you can see in above output. 
The Parent job is reporting 0 in these columns.

So, you will be able to duplicate the above images from the GUI or from cmd using bpduplicate.

When using bpduplicate, best to get a list of image id's with bpimagelist and -idonly option (instead of -U).

You can then add the list of image id's to a text file and use '-bidfile' option with bpduplicate command.

See NetBackup Commands Reference Guide: http://www.symantec.com/docs/DOC5182

View solution in original post

5 REPLIES 5

Marianne
Moderator
Moderator
Partner    VIP    Accredited Certified

ANY kind of backup can be duplicated - SQL as well. 
Best to automate duplications with SLPs or DSSU.

Have you verified that backup is still valid and not expired?

When was backup done? What is the Retention Level for 'Default Application' Schedule in the policy?

Can you list SQL backups for this client from cmd on the master?
First get exact spelling of client name in the SQL policy, then check as follows:

bpimagelist -client <client-name> -pt MS-SQL-Server -d <start-date> -U
(in ....netbackup\bin\admincmd)

Format for -d is mm/dd/yyyy

Ankit_Maheshwar
Level 5

i have to duplicate below images with infinte retention. 

 

01/08/2015 03:53  01/29/2015        2    34155  N  User Backup  0       0            abc_DB
01/08/2015 03:53  01/29/2015        5    17513  N  User Backup  0       0            abc_DB
01/08/2015 03:52  01/29/2015        5     4870  N  User Backup  0       0            abc_DB
01/08/2015 03:52  01/29/2015        2     4741  N  User Backup  0       0            abc_DB
01/08/2015 01:35  01/29/2015        2 216336884  N  User Backup  0       0            abc_DB
01/08/2015 01:35  01/29/2015       10 164235635  N  User Backup  0       0            abc_DB
01/08/2015 01:35  01/29/2015        2     4741  N  User Backup  0       0            abc_DB
01/08/2015 01:35  01/29/2015        5     4870  N  User Backup  0       0            abc_DB
01/08/2015 01:35  01/29/2015        2   336420  N  User Backup  0       0            abc_DB
01/08/2015 01:35  01/29/2015        7   572698  N  User Backup  0       0            abc_DB
01/08/2015 01:34  01/29/2015        7   675775  N  User Backup  0       0            abc_DB
01/08/2015 01:34  01/29/2015        2   956626  N  User Backup  0       0            abc_DB
01/08/2015 01:34  01/29/2015        0        0  N  Full Backup  0       0            abc_DB

 

 

 

Marianne
Moderator
Moderator
Partner    VIP    Accredited Certified

Parent job is not listed as because no actual data is transferred against the parent job.
Only Child jobs running against the Default Application are transferring data and stored in Image catalog as User Backup with values under 'Files' and 'Kbytes' as you can see in above output. 
The Parent job is reporting 0 in these columns.

So, you will be able to duplicate the above images from the GUI or from cmd using bpduplicate.

When using bpduplicate, best to get a list of image id's with bpimagelist and -idonly option (instead of -U).

You can then add the list of image id's to a text file and use '-bidfile' option with bpduplicate command.

See NetBackup Commands Reference Guide: http://www.symantec.com/docs/DOC5182

Ankit_Maheshwar
Level 5

Yes i did from command line..

 

I have a question if i did search in catalog by giving SQL server name this would not list Default Application Job.For this client command (bpimagelist -client <client-name> -pt MS-SQL-Server -d <start-date> -U)listing 13 jobs and catalog search listing 12 job. if i am duplicate catlog search 12 images with different retention. restore would work from second copy without parent job (Default application job)?

 

 

Marianne
Moderator
Moderator
Partner    VIP    Accredited Certified

As per my previous post, the command line listed the parent job as well:

01/08/2015 01:34  01/29/2015        0        0  N  Full Backup  0       0            abc_DB 

As you can see, the parent job lists 0 files and 0 Kbytes.
So, there is nothing to duplicate in this parent job.

The GUI will show you the 12 Default Application Backup jobs that contain actual data that can be duplicated and restored from.

Yes. Restore will work from the 12 duplicated images.

 

I'm having another look at your last post. Not sure I understand what you are saying?

I have a question if i did search in catalog by giving SQL server name this would not list Default Application Job

So, how are you seeing the 12 jobs in 'Catalog search'?

 .... and catalog search listing 12 job. 

These 12 jobs in 'Catalog search' seems to me the same as the ones listed in bpimagelist output?

You will see that the backup is listed as 'User Backup', which is another term for 'Default Application'.