Post reply

Mystery Backups???

  • December 19, 2005 at 6:28 am

    #111119

    Hi All,

    I've recently "inherited" a server which is not heavily used but has a small mystery attached (Naturally, no-one knows anything about it!!).

    The server has Maintenance Plan history for the databases.

    There are no visible plans or jobs and no records of them in the relevant tables in the MSDB.

    The jobs do run!!!

    It does not have any linked / remote servers.

    It does not appear to be a Target server (is there any devious way to check?)

    SQL Server Agent does not start - gives an RPC error - but RPC appears to be running ok.

    Any ideas from the guru's out there? How would I trace the origin of the Maintenance Plan? Any obvious thing that I'm missing? All advice welcome!

     


    The Aethyr Dragon

    Cape Town
    RSA

  • December 19, 2005 at 6:35 am

    #610290

    Are there any Scheduled Tasks on the server that may be running these jobs?

    The absence of evidence is not evidence of absence.
    Martin Rees

    You can lead a horse to water, but a pencil must be lead.
    Stan Laurel

  • December 19, 2005 at 7:47 am

    #610298

    If SQLAgent service was not running, the jobs cannot be ran. There must be some applications start the SPs.

    Check the plan history when the plan was running, and start profiler to trace it.

    SELECT * FROM msdb..sysdbmaintplan_history

    To check jobs owned by target servers (check Originating _server column):

    SELECT * FROM msdb..sysjobs

     

     

     

  • December 20, 2005 at 3:14 am

    #610532

    Why not forget about the mystery stuff.....move the db's to a clean server.  scrub the dodgy one and swop the clean one back in.  I know solving problems is great....but sometimes a full blown mousehunt is more expensive than a mousetrap.

  • December 20, 2005 at 11:22 am

    #610675

    You may want to take a look at the application that uses the databas. Maybe there are administrative functions within the application (we just found one that did DBREINDEX and DBCC SHRINKFILE - the code was buried in an XML file that was part of the application).

    RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."

  • December 22, 2005 at 2:37 am

    #611055

    Hi Guys,

    Thanx for all the advice / info. I'll be looking into a lot of it as soon as I can get a login for the machine. (Remote administration across domains / continents .......)

    Will let everyone know when I eventually find out what the story is.

    Tx


    The Aethyr Dragon

    Cape Town
    RSA

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply