Thanks a lot.I will reschedule.

Thanks again.....

Regards,

Devanand.

Yes the next run is scheduled to 2032. How can I change things back to normal.

After the date was changed to 2032 , scheduled jobs did run no issues. After changing the date to 2013 it doesn't .How to check the next schedule?

I have created a test job.It doesn't run. Can I reschedule all of my jobs again to the same time?

LogSQL Server Agent (Current - 5/16/2013 11:45:00 PM)

Message

Error symbol:

[364] The Messenger service has not been started - NetSend notifications will not be sent

Info symbol:

[129] SQLSERVERAGENT starting under Windows NT service...

Yes I can run it manually. Can u guide me where I can check the errors which you are asking.

Continue to the previous reply. My sa password is correct .I have scheduled the jobs using sa account only.

Here is the Service agent log:

Message

Login failed for user 'sa'. Reason: Password did not match that for the login provided. [CLIENT: 198.204.235.42]

Error: 18456, Severity: 14, State: 8.

Can anyone provide a solution to this issue.

Thanks,

Dev.

Previous time when the same kind of corruption occured, i tried dbcc with repair_allow_data_loss option. But i wanted to check if db export and import functionality to new db will...

Service Broker Msg 9675, State 1: Message Types analyzed: 14.

Service Broker Msg 9676, State 1: Service Contracts analyzed: 6.

Service Broker Msg 9667, State 1: Services analyzed: 3.

Service Broker Msg 9668,...

The full output says on table x there is 17326 consistency errors and on table y there is 13256 consistency errors.

Out of 9 tables in the db, 2 tables...

I will move all my mdf files to other drive and let you know.

Thanks,

Dev

Do you mean that I need to move all the mdf from that drive?

Is there anyway I can repair the hardware? Since it is occuring often.

The problem is the good backup of this database got expired.

Kindly clarify my below questions

When you say move the DB to different disk? I have nearly 9 DB's data...