Edit your Maintenance Plan in the Server Business Intelligence Development Studio (BIDS)
· Find SQL Server Business Intelligence Development Studio on the Start menu under Microsoft SQL Server 2005.
· From the File menu, create a New Project of type “Integration Services Project”.
· To import your Maintenance Plan into your new project, in the Solution Explorer window, right click on the ‘SSIS Packages’ folder and choose the ‘Add Existing Package’ option.
· In the “Add Copy of Existing Package” dialog
o Set the Package Location to SQL Server
o Provide authentication for your server.
o In the Package Path field , click the browse button to display the packages on your server.
o Navigate to ‘SSIS Package’, then ‘Maintenance Plans’.
o Select your Maintenance Plan and click OK. You see the Maintenance Plan that you just imported under the ‘SSIS Packages’ folder.
· Right-Click the Backup Database Task and select Properties.
· In the list of properties, navigate to the “ExpireDate” option and change the date to be at least one day ahead of the current date.
· Save the Package.
· In the Solution Explorer window, click on the name of the package. In the Properties panel, locate the Full Path to the package’s .dtsx file. Select the path and copy it to the clipboard.
· Exit the Business Intelligence Development Studio.
Re-import the Edited Package
· In Management Studio, click the Connect button and choose “Integration Services…” and connect to your server.
· Under Stored Packages open “MSDB”.
· Right click on the “Maintenance Plans” folder and select “Import Package”.
o Select “File System”.
o In the Package Path text box, paste in the previously copied .dtsx file path.
o Click in the Package Name text box to set the name, and click OK.
· When prompted to overwrite the existing package, say “Yes”.
Given these updates, the Backup Database Task should be editable from the Maintenance Plan designer.