Maintenance Plan WIzard Failure Problem

• raotor

  Hall of Fame

  Points: 3346

  More actions

  December 22, 2011 at 5:04 am

  #250258

  Hello,

  I have been trying to setup a full database backup maintenance plan and after selecting the database from the drop down window and then clicking "Next" I receive the following error.

  TITLE: Microsoft SQL Server

  ------------------------------

  This wizard will close because it encountered the following error:

  For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=10.50.1600.1&EvtSrc=Microsoft.SqlServer.Management.UI.WizardFrameworkErrorSR&EvtID=UncaughtException&LinkId=20476

  ------------------------------

  ADDITIONAL INFORMATION:

  Property BackupDirectory is not available for Settings 'Microsoft.SqlServer.Management.Smo.Settings'. This property may not exist for this object, or may not be retrievable due to insufficient access rights. (Microsoft.SqlServer.Smo)

  For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=10.50.2500.0+((KJ_PCU_Main).110617-0026+)&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.PropertyCannotBeRetrievedExceptionText&EvtID=BackupDirectory&LinkId=20476

  ------------------------------

  BUTTONS:

  OK

  ------------------------------

  When the error message appears I can see a backup dialog window, but as soon as I click "OK" on the error message the entire maintenance Plan wizard aborts.

  Any ideas?

• Devendrakumar

  SSC-Forever

  Points: 42493

  More actions

  December 22, 2011 at 5:14 am

  #1424726

  Two probable solutions... It's not tested so be extra cautious.

  http://social.msdn.microsoft.com/forums/en-US/sqlsmoanddmo/thread/3ba6d023-5899-4c5a-9270-87792840a3ba/

  http://social.msdn.microsoft.com/Forums/en-US/sqltools/thread/c788e276-d9af-411f-9af6-ec6a49e95273/