Maintenance Plan Issue

Sorry for the repost but I had an issue with my alias and had to repost per
customer service.
I'm running across a weird issue that I can't figure out. I trying to create
a maintenance plan on two of my SQL 2000 Servers. I run throught the wizard
and get to the screen to setup the backup job and when I go to select the
delete files older than option I notice that that this blank. Typically it
has dyas, hours, and weeks here. The file extension is blank as well. Aslo
the number scroll for number of files does not work correctly down is up.
Any thought on this. This is my only SQl server I've seen this on. I have 5
other SQL servers that work fine when creating a maintenance job but not on
these two servers and really need to resolve the issue on these servers.
Hello,
Thank you for posting here.
Based on the symptom, it seems the "BackupDirectory " value of the
following registry key is corrupted or missing:
HKEY_Local_Machine\Software\Microsoft\Microsoft SQL Server\<instance
name>\MSSQLServer (named instance)
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\ MSSQLServer (default
instance)
If it is missing, please right click above Key->New->String Value, change
the name to BackupDirectory, and change it value to the proper path such as:
C:\Program Files\Microsoft SQL Server\MSSQL\backup
NOTE: Using Registry Editor incorrectly can cause serious problems that may
require you to reinstall Windows. Microsoft cannot guarantee that problems
resulting from the incorrect use of Registry Editor can be solved. Use
Registry Editor at your own risk.
256986 Description of the Microsoft Windows Registry
http://support.microsoft.com/?id=256986
Have a nice day!
Best regards,
Adams Qu
MCSE, MCDBA, MCTS
Microsoft Online Support
Microsoft Global Technical Support Center
Get Secure! - www.microsoft.com/security
================================================== ===
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
================================================== ===
This posting is provided "AS IS" with no warranties, and confers no rights.
| Thread-Topic: Maintenance Plan Issue
| thread-index: Acg26I1Tyaq8Y40fRC+Uz8AX1JIRtw==
| X-WBNR-Posting-Host: 207.46.19.168
| From: =?Utf-8?B?R2VvcmdlIFNjaG5laWRlcg==?=
<georgedschneider@.noemail.noemail>
| Subject: Maintenance Plan Issue
| Date: Tue, 4 Dec 2007 18:43:01 -0800
| Lines: 12
| Message-ID: <468EAE1F-24C3-48EA-A45E-F942359AACC6@.microsoft.com>
| MIME-Version: 1.0
| Content-Type: text/plain;
| charset="Utf-8"
| Content-Transfer-Encoding: 7bit
| X-Newsreader: Microsoft CDO for Windows 2000
| Content-Class: urn:content-classes:message
| Importance: normal
| Priority: normal
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.2992
| Newsgroups: microsoft.public.sqlserver.server
| Path: TK2MSFTNGHUB02.phx.gbl
| Xref: TK2MSFTNGHUB02.phx.gbl microsoft.public.sqlserver.server:32053
| NNTP-Posting-Host: tk2msftibfm01.phx.gbl 10.40.244.149
| X-Tomcat-NG: microsoft.public.sqlserver.server
|
| Sorry for the repost but I had an issue with my alias and had to repost
per
| customer service.
|
| I'm running across a weird issue that I can't figure out. I trying to
create
| a maintenance plan on two of my SQL 2000 Servers. I run throught the
wizard
| and get to the screen to setup the backup job and when I go to select the
| delete files older than option I notice that that this blank. Typically
it
| has dyas, hours, and weeks here. The file extension is blank as well.
Aslo
| the number scroll for number of files does not work correctly down is up.
| Any thought on this. This is my only SQl server I've seen this on. I
have 5
| other SQL servers that work fine when creating a maintenance job but not
on
| these two servers and really need to resolve the issue on these servers.
|
|||Hello,
How's everything going?
I'm wondering if the suggestion has helped or if you have any further
questions. Please feel free to respond to the newsgroups if you need any
additional help.
Have a nice day!
Best regards,
Adams Qu
MCSE, MCDBA, MCTS
Microsoft Online Support
Microsoft Global Technical Support Center
Get Secure! - www.microsoft.com/security
================================================== ===
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
================================================== ===
This posting is provided "AS IS" with no warranties, and confers no rights.
| X-Tomcat-ID: 96426387
| References: <468EAE1F-24C3-48EA-A45E-F942359AACC6@.microsoft.com>
| MIME-Version: 1.0
| Content-Type: text/plain
| Content-Transfer-Encoding: 7bit
| From: v-adamqu@.online.microsoft.com (Adams Qu [MSFT])
| Organization: Microsoft
| Date: Wed, 05 Dec 2007 09:22:23 GMT
| Subject: RE: Maintenance Plan Issue
| X-Tomcat-NG: microsoft.public.sqlserver.server
| Message-ID: <p9V2aByNIHA.7908@.TK2MSFTNGHUB02.phx.gbl>
| Newsgroups: microsoft.public.sqlserver.server
| Lines: 81
| Path: TK2MSFTNGHUB02.phx.gbl
| Xref: TK2MSFTNGHUB02.phx.gbl microsoft.public.sqlserver.server:32075
| NNTP-Posting-Host: TOMCATIMPORT1 10.201.218.122
|
| Hello,
|
| Thank you for posting here.
|
| Based on the symptom, it seems the "BackupDirectory " value of the
| following registry key is corrupted or missing:
|
| HKEY_Local_Machine\Software\Microsoft\Microsoft SQL Server\<instance
| name>\MSSQLServer (named instance)
|
| HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\ MSSQLServer (default
| instance)
|
| If it is missing, please right click above Key->New->String Value, change
| the name to BackupDirectory, and change it value to the proper path such
as:
|
| C:\Program Files\Microsoft SQL Server\MSSQL\backup
|
| NOTE: Using Registry Editor incorrectly can cause serious problems that
may
| require you to reinstall Windows. Microsoft cannot guarantee that
problems
| resulting from the incorrect use of Registry Editor can be solved. Use
| Registry Editor at your own risk.
|
| 256986 Description of the Microsoft Windows Registry
| http://support.microsoft.com/?id=256986
|
| Have a nice day!
|
| Best regards,
|
| Adams Qu
| MCSE, MCDBA, MCTS
| Microsoft Online Support
|
| Microsoft Global Technical Support Center
|
| Get Secure! - www.microsoft.com/security
| ================================================== ===
| When responding to posts, please "Reply to Group" via your newsreader so
| that others may learn and benefit from your issue.
| ================================================== ===
| This posting is provided "AS IS" with no warranties, and confers no
rights.
|
|
| --
| | Thread-Topic: Maintenance Plan Issue
| | thread-index: Acg26I1Tyaq8Y40fRC+Uz8AX1JIRtw==
| | X-WBNR-Posting-Host: 207.46.19.168
| | From: =?Utf-8?B?R2VvcmdlIFNjaG5laWRlcg==?=
| <georgedschneider@.noemail.noemail>
| | Subject: Maintenance Plan Issue
| | Date: Tue, 4 Dec 2007 18:43:01 -0800
| | Lines: 12
| | Message-ID: <468EAE1F-24C3-48EA-A45E-F942359AACC6@.microsoft.com>
| | MIME-Version: 1.0
| | Content-Type: text/plain;
| | charset="Utf-8"
| | Content-Transfer-Encoding: 7bit
| | X-Newsreader: Microsoft CDO for Windows 2000
| | Content-Class: urn:content-classes:message
| | Importance: normal
| | Priority: normal
| | X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.2992
| | Newsgroups: microsoft.public.sqlserver.server
| | Path: TK2MSFTNGHUB02.phx.gbl
| | Xref: TK2MSFTNGHUB02.phx.gbl microsoft.public.sqlserver.server:32053
| | NNTP-Posting-Host: tk2msftibfm01.phx.gbl 10.40.244.149
| | X-Tomcat-NG: microsoft.public.sqlserver.server
| |
| | Sorry for the repost but I had an issue with my alias and had to repost
| per
| | customer service.
| |
| | I'm running across a weird issue that I can't figure out. I trying to
| create
| | a maintenance plan on two of my SQL 2000 Servers. I run throught the
| wizard
| | and get to the screen to setup the backup job and when I go to select
the
| | delete files older than option I notice that that this blank.
Typically
| it
| | has dyas, hours, and weeks here. The file extension is blank as well.
| Aslo
| | the number scroll for number of files does not work correctly down is
up.
|
| | Any thought on this. This is my only SQl server I've seen this on. I
| have 5
| | other SQL servers that work fine when creating a maintenance job but
not
| on
| | these two servers and really need to resolve the issue on these servers.
| |
|
|