Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AndyThissen
Starting Member
7 Posts |
 Posted - 2005-03-25 : 17:54:02
|
| Please can someone at least explain why I can't use the DatabaseMaintenance Plan Wizard in SQL Enterprise Manager SP3 to create amaintenance plan on a default instance of MSDE 2000 SP3?Specifically, on the database backup page:* the location selection is not remembered* the default file extension is blank, not ".BAK"* there are no units of time in the retention period pull-downlistbox, where there should be Minute(s), Hour(s), Day(s), Week(s),Month(s) |
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2005-03-25 : 21:02:20
|
| sqlmaint.exe was missing from MSDE 2000, but that was fixed in SP1 I think. Since this is SP3 you probably have a missing registry value for the backup directory.I had to fix a similar problem last year on a bunch of laptops. They were all missing a registry value. Anyway, here is the fix:1. Fire up regedit and look under HKLM\SOFTWARE\Microsoft\MSSQLServer\MSSQLServer2. Ensure you have a string value called BackupDirectory. The value for this should be the path to your backup dir. The default value is C:\Program Files\Microsoft SQL Server\MSSQL\BACKUP btw, this fix assumes you have a default instance installed. A named instance will have slightly different registry location and filesystem path.-ec |
 |
|
|
AndyThissen
Starting Member
7 Posts |
Posted - 2005-03-28 : 09:13:07
|
| Thanks, That was exactly it. I can't believe there was no KB article on this because I seemed to have no problem duplicating the issue.Thank you again. |
|
|
|
tazigdad
Starting Member
1 Post |
Posted - 2014-10-29 : 12:14:10
|
Thank you for posting this it works like a charm. Also Kudos to you for such great instructions. quote:
Originally posted by eyechart
sqlmaint.exe was missing from MSDE 2000, but that was fixed in SP1 I think. Since this is SP3 you probably have a missing registry value for the backup directory.I had to fix a similar problem last year on a bunch of laptops. They were all missing a registry value. Anyway, here is the fix:1. Fire up regedit and look under HKLM\SOFTWARE\Microsoft\MSSQLServer\MSSQLServer2. Ensure you have a string value called BackupDirectory. The value for this should be the path to your backup dir. The default value is C:\Program Files\Microsoft SQL Server\MSSQL\BACKUP btw, this fix assumes you have a default instance installed. A named instance will have slightly different registry location and filesystem path.-ec
|
|
|
|
|
|
|
|
|
MSDE SP3- can't create maintenance plan