DB manitenance job failing - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Administration (2000)

DB manitenance job failing

Author

Topic

venkath
Posting Yak Master

202 Posts

Posted - 2007-02-24 : 02:31:17

Hi all

We have a maintenance plan to take full back every sunday and transaction log backups every 4 hours on the following databases.

E2PT,S2PT,M3PT.

For the last 3 days the job is not running..The job is enabled when i tried to restart the job..it is failing..

From SQLSERVERAGENT logs.. i found some thing like below for the last 3 days.

Job TESTSERVER-M3PT-TESTSERVER-7 was deleted while it was executing: the outcome was Succeeded
2007-01-23 11:24:47 - + [180] Job TESTSERVER-M3PT-7 was deleted while it was executing: the outcome was (Unknown)
2007-02-20 11:10:00 - ! [264] An attempt was made to send an email when no email session has been established
2007-02-20 11:10:01 - ! [298] SQLServer Error: 4060, Cannot open database requested in login 'M3RT'. Login fails. [SQLSTATE 42000] 
2007-02-20 11:10:01 - ! [264] An attempt was made to send an email when no email session has been established
2007-02-20 11:10:02 - ! [298] SQLServer Error: 4060, Cannot open database requested in login 'M3RT'. Login fails. [SQLSTATE 42000] 
2007-02-20 11:10:02 - ! [264] An attempt was made to send an email when no email session has been established
2007-02-20 11:10:05 - ! [298] SQLServer Error: 4060, Cannot open database requested in login 'M3RT'. Login fails. [SQLSTATE 42000] 
2007-02-20 11:10:05 - ! [264] An attempt was made to send an email when no email session has been established
2007-02-20 11:10:06 - ! [298] SQLServer Error: 4060, Cannot open database requested in login 'M3RM'. Login fails. [SQLSTATE 42000] 
2007-02-20 11:10:06 - ! [264] An attempt was made to send an email when no email session has been established
2007-02-20 11:10:08 - ! [264] An attempt was made to send an email when no email session has been established
2007-02-20 11:15:00 - ! [298] SQLServer Error: 4060, Cannot open database requested in login 'M3RT'. Login fails. [SQLSTATE 42000] 
2007-02-20 11:15:00 - ! [264] An attempt was made to send an email when no email session has been established
2007-02-20 11:15:02 - ! [298] SQLServer Error: 4060, Cannot open database requested in login 'M3RM'. Login fails. [SQLS

Please let me know..what caused this issue.

eyechart
Master Smack Fu Yak Hacker

3575 Posts

Posted - 2007-02-24 : 02:46:04

i think the default database for the M3RT user was deleted or changed in some way. Have you recently dropped any databases in this system?

-ec

venkath
Posting Yak Master

202 Posts

Posted - 2007-02-24 : 02:55:28

yes..i have dropped a database and forgot to remove it from maintenance plan..

Thanks for ur quick reply.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources