Cant take Backups

Hi
I have Database in SQL-Server2000 size is 1.37 GB i am tryn to take backup followin are the problems:-
1. Maintainence Plan for Backup Fails for DB
2. Jobs fails for Backup

--> I goto SQL Server Logs Error message is Operating system error 23(Data error (cyclic redundancy check).)

--> Now i am tryin Backup using command :-
Backup Database 'DB1' To Disk ='Path' followin error occurs:-
"Nonrecoverable I/O error occurred on file"

--> Now i am doing back-up directly from Enterprise Manager following error message occurs same error comes

Whats surprising Jobs, maintainence plan, Backup for other database is working perfectly, i checked HDD doesnt have any bad blocks etc. i have even changed path for Backups but still only for these database it gives problem

With Regards

Have you issued a DBCC CHECKDB against the database?

WesleyB

Visit my SQL Server weblog @. http://dis4ea.blogspot.com

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 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