can't set backup retention

We have a SQL 2000 MSDE when I use maintenance plan to set up
backups, Remove files older than window, when I click on the screw down lit
for the options (minutes, hours, days, weeks, months), there is nothing to
choose.
I remember there is an msde table or something needs to add. I forgot about
it...
Any advice from Microsoft...
I have searched on google, nothing showing up except talking about SQL
2005...This is only for SQL 2000 MSDE.Hi everybody,
Can I get answer for this today'
"renhai" wrote:

> We have a SQL 2000 MSDE when I use maintenance plan to set up
> backups, Remove files older than window, when I click on the screw down li
t
> for the options (minutes, hours, days, weeks, months), there is nothing t
o
> choose.
> I remember there is an msde table or something needs to add. I forgot abou
t
> it...
> Any advice from Microsoft...
> I have searched on google, nothing showing up except talking about SQL
> 2005...This is only for SQL 2000 MSDE.
>|||I think maybe your are thinking about the missing registry
key. That process executes:
xp_instance_regread N'HKEY_LOCAL_MACHINE',
N'SOFTWARE\Microsoft\MSSQLServer\MSSQLSe
rver',
N'BackupDirectory'
If there is no BackupDirectory string value in the key
HKLM\Software\Microsoft\MSSQLServer\MSSQ
LServer, you get an
error and nothing is displayed for the time increments.
-Sue
On Fri, 19 May 2006 14:58:01 -0700, renhai
<renhai@.discussions.microsoft.com> wrote:

>We have a SQL 2000 MSDE when I use maintenance plan to set up
>backups, Remove files older than window, when I click on the screw down lit
>for the options (minutes, hours, days, weeks, months), there is nothing to
>choose.
>I remember there is an msde table or something needs to add. I forgot about
>it...
>Any advice from Microsoft...
>I have searched on google, nothing showing up except talking about SQL
>2005...This is only for SQL 2000 MSDE.sql

can't set backup retention

We have a SQL 2000 MSDE when I use maintenance plan to set up
backups, Remove files older than window, when I click on the screw down lit
for the options (minutes, hours, days, weeks, months), there is nothing to
choose.
I remember there is an msde table or something needs to add. I forgot about
it...
Any advice from Microsoft...
I have searched on google, nothing showing up except talking about SQL
2005...This is only for SQL 2000 MSDE.Hi everybody,
Can I get answer for this today'
"renhai" wrote:
> We have a SQL 2000 MSDE when I use maintenance plan to set up
> backups, Remove files older than window, when I click on the screw down lit
> for the options (minutes, hours, days, weeks, months), there is nothing to
> choose.
> I remember there is an msde table or something needs to add. I forgot about
> it...
> Any advice from Microsoft...
> I have searched on google, nothing showing up except talking about SQL
> 2005...This is only for SQL 2000 MSDE.
>|||I think maybe your are thinking about the missing registry
key. That process executes:
xp_instance_regread N'HKEY_LOCAL_MACHINE',
N'SOFTWARE\Microsoft\MSSQLServer\MSSQLServer',
N'BackupDirectory'
If there is no BackupDirectory string value in the key
HKLM\Software\Microsoft\MSSQLServer\MSSQLServer, you get an
error and nothing is displayed for the time increments.
-Sue
On Fri, 19 May 2006 14:58:01 -0700, renhai
<renhai@.discussions.microsoft.com> wrote:
>We have a SQL 2000 MSDE when I use maintenance plan to set up
>backups, Remove files older than window, when I click on the screw down lit
>for the options (minutes, hours, days, weeks, months), there is nothing to
>choose.
>I remember there is an msde table or something needs to add. I forgot about
>it...
>Any advice from Microsoft...
>I have searched on google, nothing showing up except talking about SQL
>2005...This is only for SQL 2000 MSDE.

Can't see Mapped Drives in Database Maintenance tool!

I have SQL2000 & SQL2005 running on Windows 2003 servers.
I am using the Database Maintenance tool to backup selected databases. I
realized the only drives I can save these backups to are the local drives. We
don't have enough space on these local drives, so is there anyway to see the
network mapped drives for this procedure?
Thanks,
Ted
Don't use a mapped drive. Use the UNC pathing instead. You need to ensure
the account SQL Server is running under has permissions to read and write to
this share first.
http://support.microsoft.com/kb/555128
Andrew J. Kelly SQL MVP
"Infomax" <Infomax@.discussions.microsoft.com> wrote in message
news:EBB765BE-0A41-456C-9615-C6AB069AAADB@.microsoft.com...
>I have SQL2000 & SQL2005 running on Windows 2003 servers.
> I am using the Database Maintenance tool to backup selected databases. I
> realized the only drives I can save these backups to are the local drives.
> We
> don't have enough space on these local drives, so is there anyway to see
> the
> network mapped drives for this procedure?
> Thanks,
> Ted

Can't run the scheduled SQL Agent Job?

Hi,

I'm tried to run the job that created from maintenance plan. It fail and give me the following message:

[298] SQLServer Error: 15404, Could not obtain information about Windows NT group/user 'DOMAIN\MYNAME', error code 0x5. [SQLSTATE 42000] (ConnIsLoginSysAdmin)

We are using the Windows Autheniciaton mode only and my id is set as sysadmin, setadmin, processadmin in the server roles.

I don't why I can't run the job, I check the SQL agent services is login using LOCALSYSTEM.

I try to the NT admin account to login the box, but still getting the same error message.

Any idea?

Thanks!

use a local login for the SQLAgent and try to schedule it again.|||

Hi,

What is local login? we only setup use the windows authenication mode for the sql server?

Thanks!

|||

this may help u : http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=102884&SiteID=1

change the owner of the job

Madhu

|||

Is the SQL Server machine in the same domain as the user mentioned in the error message?

The 0x5 error code means access denied - the DC doesn't allow you to query the user information. If there are different domains involved, you may need to set the trust between them.

Also, what did you say you tried at the end of your message? There is a word missing I think.

Thanks
Laurentiu

Can''t management maintenance plans in SQL Mgmt Studio

When I click on the "Maintenance Plans" node in SQL Management Studio, I get an error:

TITLE: Microsoft SQL Server Management Studio

Failed to retrieve data for this request. (Microsoft.SqlServer.SmoEnum)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&LinkId=20476

ADDITIONAL INFORMATION:

An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)

Invalid column name 'from_msx'.
Invalid column name 'has_targets'. (Microsoft SQL Server, Error: 207)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.3042&EvtSrc=MSSQLServer&EvtID=207&LinkId=20476

BUTTONS:

OK

As you can imagine, the links take me to a "We're sorry... no additional info available" message. Has anyone else seen this, or better yet, resolved it?

--Geoff

I think you need to have SQL 2005 SP2 refer,

http://207.46.236.188/MSDN/ShowPost.aspx?PostID=1757393&SiteID=1

Can''t management maintenance plans in SQL Mgmt Studio

When I click on the "Maintenance Plans" node in SQL Management Studio, I get an error:

TITLE: Microsoft SQL Server Management Studio

Failed to retrieve data for this request. (Microsoft.SqlServer.SmoEnum)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&LinkId=20476

ADDITIONAL INFORMATION:

An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)

Invalid column name 'from_msx'.
Invalid column name 'has_targets'. (Microsoft SQL Server, Error: 207)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.3042&EvtSrc=MSSQLServer&EvtID=207&LinkId=20476

BUTTONS:

OK

As you can imagine, the links take me to a "We're sorry... no additional info available" message. Has anyone else seen this, or better yet, resolved it?

--Geoff

I think you need to have SQL 2005 SP2 refer,

http://207.46.236.188/MSDN/ShowPost.aspx?PostID=1757393&SiteID=1