Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2004
    Location
    Canada
    Posts
    2

    Arrow Unanswered: Droping Log File

    I have two transaction log files, one on C drive and other on D drive. I want to drop the file from that database that is on C drive. Can anyone help me out on this with complete syntax.

    I have taken a down time of one and half hour to accomplish this task

    Here is what think

    Take a full database backup
    Take transaction log backup
    Shrinkfile using DBCC with truncateonly option
    emptyfile using dbcc or drop file using alter database remove

    thanks for your input guys


    Rome

  2. #2
    Join Date
    Sep 2003
    Location
    Dallas, Texas
    Posts
    311

    Re: Droping Log File

    You can do it all on EM. But the most important thing is to do a checkpoint to make sure everything is on disk, and then do a log backup. The log file should be empty, and you should be able to delete the log file from EM.

Posting Permissions

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