Post reply

Transaction Log backup

  • March 15, 2010 at 10:25 am

    #145942

    Hi,

    backup of transaction logs are taking place in one of my servers. I don't exactly where the files are coming from.

    There are two jobs to backup the transaction; they are failing but, if I go to the STANDBY, there are transaction log files. Can anyone tell me how and where they are coming from?

    Thanks

  • March 15, 2010 at 10:28 am

    #1133874

    Check the jobs and see what is the back up files path for the jobs, can you post the failing jobs error message here?

    EnjoY!

  • March 15, 2010 at 10:34 am

    #1133881

    If someone is not doing the backups manually, there is a job to do them. If it's from a maintenance plan, it should have a name for a job that makes sense.

    You can read the history for the job, but it doesn't always give the details. If it's a maintenance plan, hopefully there is a detailed text log. Open the package and check for the path to the files and then look for one of them.

  • March 15, 2010 at 11:02 am

    #1133897

    Steve and GTR have provided good information.

    The log backups are due to either a job or a manual intervention.

    You also might want to verify if Log-Shipping is present.

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • March 15, 2010 at 11:25 am

    #1133915

    @@@ Steve, GTR and Jason; Thank you for your response.

    There is no maintenance plan for transaction log backup. Logshipping is not taking place.

    But, there are transaction log backups in the standby server. The only thing is I am observing is, there are two jobs for the transaction log backups, which are failing. I wonder, how the log backups are taking place while the jobs are failing. When I view the job history, I am getting the message:

    The job failed. The Job was invoked by Schedule 2 (Log Schedule). The last step to run was step 1 (Log Backup).

    I am guessing that the transaction log backup might have been taking place throgh VERITAS, but I am not sure.

    Is there anyway, we can find, where it is coming from by looking at the transaction log file that was backed up to Standby?

    Thank You.

  • March 15, 2010 at 11:29 am

    #1133918

    I have seen Veritas report as failed but the job is actually successful. What is the extension of your log backup files (IIRC Veritas likes to use a different file extension). Also, look in your Veritas jobs and check there. The veritas agent is likely installed on the server and you should be able to access it and check its logs.

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

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

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