by Sarma Musty, Senior Consultant
Problem Statement
Here we tried to solve the problem as mentioned the following link.
The developer created a Maintenance Plan using SQL Server 2005 Maintenance Plan Wizard. The tasks included a backup database task. The Maintenance Plan package (SSIS) was exported to a different Server. While trying to edit the Backup Database task, the system threw the following error.
Figure 1 - Error while editing the Back DB Task
Background
In SSIS, Backup Database Task is used to backing databases. The following diagram shows the screen for editing Backup Database Task. User can list the databases that need to be backed up and also provide information about locations, devices etc. The backup can be done on a Tape or Disk.
User can select “Backup databases across one or more files” and manually provide the list of backup files (Manual Option). Or he/she can select “Create a backup file for every database” and give a path for the backups (Auto Option). In this option system will generate backup files automatically. This property is saved in “DestinationCreationType” attribute of Backup Database Task properties.
Figure 2 - Edit Screen on Back DB Task
Figure 3 - Backup DB Task Properties
In the problem, the setting that the developer opted was manual and a backup file location was also provided. The system was not able to recognize this list. Possible reasons could be that system was not able to recognize the location or device that’s defined in the task. Nevertheless, the error message does not give any details about the actual reason.
Solution
As a work around, we changed the DestinationCreationType property from Manual to Auto. After this change the edit screen of the Back Datbase Task is working as expected.
0 comments:
Post a Comment