if any links provided is helpful  to me

thanks for the replies .

Thanks for the update .

Sone of the stored procedures having 3 naming  in the database if we restored with different name it will point to the old database name . How to resolve the...

we are not sure the query as it is getting my tool  , may i know what are the reasons of getting this error and any idea to resolve this...

i am using the standard Proc to recycle the  error log'sp_cycle_agent_errorlog ', even i  tried to run in different schedule.

Is  the query will provide  the drop syntax of all the tables _backup or it will delete the tables on a database .

As we  renamed sa login to anothet name and want to change the dbowners of all databases  but later versions like 2o12 onwards  dbowner of sys databases are changed ,...

in sql 2005/sql2008

Thanks for the responses ..not sure  whether the applicatoins will use the sa login .

no i will not disable  the login  after   renaming the sa .

We are having issues  in  restoring job   and it is failing  so need to restore manually the last backups to sync

Thanks

i checked the sqlagent.out file and also the msdb.subsystem , as the sql is installed on D drive the log reader  subsystem file is in D drive .

checked the sql agent out file but did not find any information execpt the

Step 1 failedreason: The LogReader subsystem failed to load [see the SQLAGENT.OUT file for details]; The job...