Results 1 to 3 of 3
  1. #1
    Join Date
    Aug 2004
    Location
    Calgary, Alberta
    Posts
    106

    Unanswered: transaction log files

    Hi,

    I'm wondering if when adding another transaction log file, if the DB needs to be detached in order to remove that file. Or rather, what do you have to do in order to reduce the number of transaction log files..?

    Cheers,
    -Kilka

  2. #2
    Join Date
    Jan 2003
    Location
    Massachusetts
    Posts
    5,800
    Provided Answers: 11
    I am not sure what you are trying to do. Are you looking to move a logfile from one place to another? Hopefully from one physical drive to another?

    Anyway, you can remove a logfile, so long aas you have at least one left. You can never have a database with no logfiles. Look up dbcc shrinkfile (fileid, 'emptyfile') in books online. That should be enough to get you started, anyway. If not, let us know.

  3. #3
    Join Date
    Aug 2004
    Location
    Calgary, Alberta
    Posts
    106
    You just answered my question.

    Thanks MCrowley, I appreciate the help.

    Regards,
    -Kilka

Posting Permissions

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