NMM SQL backup with Backup template is not using the configured Pool

Summary: With 19.10 we can use backup templates to enable Retention Lock on client-initiated backups. The defined pool is not honored when running nsrsqlv, instead the Default Pool is requested. ...

This article applies to This article does not apply to This article is not tied to any specific product. Not all product versions are identified in this article.
Check out other resources

Symptoms

To enable retention lock on the NMM SQL client initiated backup we use a backup template that sets retention, retention lock time and pool.

 

The Backup template:

                        type: NSR backup template;
                        name: 1month;
                     comment: ;
                     clients: ;
                storage node: ;
                 volume pool: RLpool;
            retention policy: Month;
               browse policy: Month;
     Apply DD retention lock: Yes;
      DD retention lock time: Month;

 

Command:

C:\> nsrsqlv.exe -s myserver -a template=1Month -1 full MSSQL:
…
174908:nsrsqlsv: Saving the backup data in the pool 'Default'.
…


        
Cause

        
This issue was caused by a code defect.

        
Resolution

        
As a workaround you can add the Pool parameter to the command:
 
  
C:\> nsrsqlv.exe -s myserver -a template=1Month -1 full -b RLpool MSSQL:
 
  
 
  
 
 
  
 


            


        

        
        
Products

        NetWorker Family, NetWorker, NetWorker Module for Microsoft







                        

                            

    

        

            

                
                    
 Article Properties

                
            

            

                

                        
Article Number: 000242046

                

                
                

                        
Article Type: Solution

                

                

                        
Last Modified: 28 Nov 2024


                

                    

                            
Version:  1

                    


            


        

    

    

        

            

                
                    
Find answers to your questions from other Dell users

                
            

            

                

                    
                



            


        

    

    

        

            

                
                    
Support Services

                
            

            

                

                    Check if your device is covered by Support Services.