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
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
0 Comments:
Post a Comment
<< Home