STATUS CODE 2: Microsoft SQL backups fail with a NetBackup Status Code 2 “none of the requested files were backed up”
SQL Client Configuration:
1. Configure the NetBackup client service (Admin ToolsServices) to run as the account that you are logged in as and then restart the service (Figure 1).
Figure 1
2. Open the NetBackup MS SQL GUI a prompt to ‘set your DBMS Login Parameters‘ will appear. Ā Reenter the same account info that the NetBackup client service is running as (Figure 2).
Figure 2
3. ChooseĀ ActionsBackupDatabaseĀ and select the database(s) to be backed up, enter the policy name (this is optional) and select ‘save for later execution‘ and then click onĀ OK. Ā Enter a file name and then save. Ā If the script is saved in the default location, only the script name is necessary to be referenced in the policy.
4. Client configuration portion is now completed, please perform the next steps from the NetBackup Administration Console.
MS-SQL-Server Policy Configuration:
1. OpenCreate a MS-SQL-Server policy. Ā Verify that the Default-Application-Backup schedule is set to 24 x 7 and add a new schedule type ‘automatic backup‘ and set the start window to the desired schedule in which SQL backups are to be run.
2. On theĀ ClientsĀ tab addverify that the client name is entered correctly.
3. On theĀ Backup SelectionsĀ tab, enter the name of the backup script that was created on the client (i.e.Ā backup.bch). Ā NetBackup will look for this script in the default location on the client to run it.
NOTE: Ā If backing up multiple clients with a single policy then thereĀ mustĀ be a common script name on each of the clients listed! Ā The contents of each script will be unique for each client. For example: a policy exists on one SQL client with a script namedĀ DailyFull.bchĀ in the default directory of ‘C:Program FilesVERITASNetBackupDbExtMsSql‘. Ā A month later, another SQL server is added with the above client configuration steps. TheĀ .bchĀ file is saved on the new client asĀ DailyFull.bchĀ in the default directory. Ā At this point, it is only necessary to add the client name to the ‘Clients‘ tab of the MS-SQL-Server policy. Ā Figure 3 is an example of an MS-SQL-Server policy properly configured to backup multiple clients.
Figure 3
NetBackup SQL agent backup configuration is now completed, right click on the policy and choose ‘Manual Backup‘ to test.