Forum Discussion

Ankit_Maheshwar's avatar
Ankit_Maheshwar
Level 5
11 years ago
Solved

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. 

 

7.5
Agent for Microsoft SQL Server
Backing Up
Backup and Recovery
NetBackup
Windows 8
  • Marianne's avatar
    Marianne
    11 years ago

    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

5 Replies

  • Marianne's avatar
    Marianne
    Level 6
    11 years ago

    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's avatar
    Ankit_Maheshwar
    Level 5
    11 years ago

    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's avatar
    Marianne
    Level 6
    11 years ago

    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's avatar
    Ankit_Maheshwar
    Level 5
    11 years ago

    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's avatar
    Marianne
    Level 6
    11 years ago

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