Results 1 to 5 of 5

Thread: delete log file

  1. #1
    Join Date
    Dec 2004
    Posts
    2

    Unanswered: delete log file

    Our server is getting pretty full, the data has already been backed up, but it did not create additional room on the server. Can I delete the log file as long as I have backed up the items I need? We are running Microsoft SQL 2000.

    Thanks for the help!

  2. #2
    Join Date
    Dec 2004
    Location
    York, PA
    Posts
    95

    Shrink your DB's

    Then compress and shrink the log files too

    That if you have not done it before should clear up some space...

    You do backup to a different drive/ server right?

  3. #3
    Join Date
    Dec 2004
    Posts
    2

    can I delete the log files?

    Thanks for the response. Yes, we do back up to another drive. Do you know what happens if you erase the log files?

  4. #4
    Join Date
    Jul 2003
    Location
    San Antonio, TX
    Posts
    3,662
    Quote Originally Posted by shawnad
    ...Do you know what happens if you erase the log files?
    The database becomes inaccessible. If you deleted the log file AFTER you detached the database, then you'll have hard time recovering it unless you plan to restore it from the backup. If you deleted it AFTER you stopped SQL service, then upon the next service startup the database will be marked Suspect. This situation can be easily fixed using 1 of the 3 known methods.
    "The data in a record depends on the Key to the record, the Whole Key, and
    nothing but the Key, so help me Codd."

  5. #5
    Join Date
    Feb 2004
    Location
    San Antonio, TX
    Posts
    565
    Quote Originally Posted by rdjabarov
    The database becomes inaccessible. If you deleted the log file AFTER you detached the database, then you'll have hard time recovering it unless you plan to restore it from the backup. If you deleted it AFTER you stopped SQL service, then upon the next service startup the database will be marked Suspect. This situation can be easily fixed using 1 of the 3 known methods.

    I SUSPECT that you are going to tell him.

Posting Permissions

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