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.
| Author |
Topic |
|
vdavid70
Yak Posting Veteran
67 Posts |
 Posted - 2006-11-09 : 11:25:28
|
| I have come accross a rather funny state with one of the sql servers i manage.The Sql server is sql server 2000(sp4), residing on a windows server 2003 standard edition service pack1.I ran a backup of all the databases on this server with no problems at all. But when i use the database maintainance plan to schedule the backups, it fails. When i check the job from sql server agent it doesnt change the job icon to red and there is no history for the job.Secondly when i check the history of the job from the databse maintainance window, it seems to have disappeared. On checking the sql server error logs or agent logs it doesnt report there has been any errors on the server.The only place where i can get information on whats going on is the windows error logs.Below is a copy of the log"SQL Server Scheduled Job 'DB Backup Job for DB Maintenance Plan 'DB Maintenance Plan5'' (0x04466652C114104684A9D751B9FE264B) - Status: Failed - Invoked on: 2006-11-09 15:35:35 - Message: The job failed. Unable to determine if the owner (3P) of job DB Backup Job for DB Maintenance Plan 'DB Maintenance Plan5' has server access (reason: Unable to connect to server - check SQL Server and SQL Server Agent errorlogs).After reading this error i try to run the job again using all sorts of logins including the SA one. Yet it comes up with the same error.Finally, the most anoying part is i try to run the syslogins and sysusers stored procedures from QA and it comes up saying these users are not in the databse, yet i can see them within enterprise manager, login with them and even run jobs manually with them.Someone please please helpNow to tup it all i stopped and restarted sql server agent but it wont start now. |
|
|
mightypenny_ph
Yak Posting Veteran
54 Posts |
Posted - 2006-11-10 : 02:29:47
|
| please post your job scripts... :)SlayerS_`BoxeR` + [ReD]NaDa |
 |
|
|
KenW
Constraint Violating Yak Guru
391 Posts |
Posted - 2006-11-10 : 15:53:23
|
vDavid,quote:
Unable to connect to server - check SQL Server and SQL Server Agent errorlogs
So, did you check the SQL Server and SQL Server Agent logs? If so, what did they say? If not, please follow the instructions in the error message and check them.Ken |
|
|
|
|
|
|
SQL Maintainance Plan