Highlighted

SQL backup duplication.

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 Solution

Accepted Solutions
Accepted Solution!

Parent job is not listed as

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

ANY kind of backup can be

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

i have to duplicate below

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

 

 

 

Accepted Solution!

Parent job is not listed as

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

Yes i did from command

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)?

 

 

As per my previous post, the

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