July 31, 2003 at 3:03 pm
I have a few different DB's that I take care of, one is a real SQLServer2000 DB, and the other 2 are MSDE 2000 DBs. I have setup maintenance plans for all 3 (including backups), and they seem to be working great. However, while in a maintenance plan, on the Complete Backup tab, you can specify "remove files older than" x, and then you can specify the timeframe; like days, weeks, etc.
When I am hitting my real SQL2000 DB, this box displays the options such as days, weeks, months. However, on the 2 MSDE 2000 DB's, nothing shows in this drop-down box. Has anyone come across this before? Is there a fix?
Thank you in advance.
August 4, 2003 at 8:00 am
This was removed by the editor as SPAM
August 4, 2003 at 12:38 pm
I'll have to admit to having never set up a maintenance plan on an MSDE instance. Didnt even know you could! Have to add it to my list of things to work more with I guess.
Andy
August 26, 2004 at 1:38 pm
I am encountering the same problem with MSDE 2000 Sp3. I have not discovered a fix for it yet.
David Bird
August 26, 2004 at 2:37 pm
A registry entry needs to be added. I copied the post from another site. Here it is.
This is a known issue and is logged as bug #364064. We don't currently have
a fix available, but we have tested a workaround for this issue.
WARNING: If you use Registry Editor incorrectly, you may cause serious
problems that may require you to reinstall your operating system. Microsoft
cannot guarantee that you can solve problems that result from using Registry
Editor incorrectly. Use Registry Editor at your own risk.
If you add the BackupDirectory registry value for the instance SQL server in
registry, you will be able to add, save, and edit the maintenance job.
For example, (if you have a default instance), put it in
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\MSSQLServer.
The String value is "BackupDirectory" and the data value is "C:\Program
Files\Microsoft SQL Server\MSSQL\BACKUP"
For example, (if you have a named instance), put it in
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\<instance
name>\MSSQLServer.
The String value is "BackupDirectory" and the data value is "C:\Program
Files\Microsoft SQL Server\MSSQL$instancename\BACKUP"
-Dan Holt
--
David Bird
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply