teamRobin

Tuesday, February 14, 2006

Unpopulated days, weeks, months drop down in SQL Server enterprise manager maintenance wizard + Error 8114 using the Management Wizard

Other might find this useful. Was hard to find a fix for this.

Even searching support.microsoft.com yielded nothing after I solved it.

Issue 1: Also you will get an 8114 error when editing the package in the wizard.

Issue 2: unpopulated days, weeks, months drop down in SQL Server enterprise manager maintenance wizard.

Solution:
Related to a missing registry value for the backup directory. On a applicable instance, you would add a new string value to: HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\MSSQLServer The new string value is BackupDirectory The data value for this is the path to your backup directory. The default would be :\Program Files\Microsoft SQL Server\MSSQL\BACKUP

0 Comments:

Post a Comment

<< Home