Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2003
    Location
    Switzerland
    Posts
    1

    Question Unanswered: Transaction Logs aren't deleted from mainenance task (newbie)

    I created one maintenence task which backs up the data files and also the logs from some databases.
    He shut delete each file after seven days, the data files are deleted, but the logs are not deleted.

    Wy does he not delete the log files after seven days?


    The transaction log backup occurs on 00:00 each day and the datafile backup occurs on 02:00 in the morning, which is no object in my opinion.

    Thank you in advence

    bobele

  2. #2
    Join Date
    Dec 2002
    Location
    Amsterdam
    Posts
    12

    Re: Transaction Logs aren't deleted from mainenance task (newbie)

    Originally posted by bobele
    I created one maintenence task which backs up the data files and also the logs from some databases.
    He shut delete each file after seven days, the data files are deleted, but the logs are not deleted.

    Wy does he not delete the log files after seven days?


    The transaction log backup occurs on 00:00 each day and the datafile backup occurs on 02:00 in the morning, which is no object in my opinion.

    Thank you in advence

    bobele
    Gruss Gott bobele,
    What do you mean that he should 'delete' the datafile? Is removing the database part of your maintenanceplan?? You mean shrink?
    Do you have sql7 or 2000?

Posting Permissions

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