Results 1 to 2 of 2
  1. #1
    Join Date
    May 2003
    Location
    Sydney AU
    Posts
    15

    Unanswered: Elusive Backup Process

    Howdy Folks,

    I have recently taken over looking after this machine & the previous guardian is unavailable. I've got to a point where I'm starting to think about looking into MSDB, but am not overly keen to start reviewing this db for obvious reasons... Can anyone please offer advise ?

    Thank In Advance
    Suze.

    Environment: Microsoft SQL Server 2000 - 8.00.760 (sp3) on Win2000
    H/W Dell PowerEdge 2550

    Issue: Discovered in the sql log that there is a second set of bkps occurring around 7:30am - the bkps we have setup, run at 2am & are also being logged to sql log as completing normally.

    The 7:30am bkps appear to be backing up to a remote location using pipes... or at a guess an agent ?? (I don't know know what that looks like cos we don't use agents). We backup db's to disk and then let arcserve pick up those backup files later.

    I assume that this has been occurring for some time, sql logs back to July 7 advise so... Unable to locate scheduled job / maintenance plan that runs at this time...

    Last night I set up a trace to catch it but that hasn't helped me either, apart from telling me that its an internal process to the server, and that the process actually started at 6:50am.

    SQL LOGS Entries between midnight & 8am in attached file:

    Trace contents in attached zip file:
    Attached Files Attached Files

  2. #2
    Join Date
    May 2003
    Location
    Sydney AU
    Posts
    15

    Found the answer - finally

    Someone had the sql agent installed on this server previously. It appears that the NT backup person still had it selected in the backup as well as the backups to disk. We have now removed this & shall wait and see tonight but I guess I now know what a remote agent arcserve backup looks like.

    Cheers

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •