Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2003
    Location
    India
    Posts
    523

    Unanswered: moving transaction log file to another disk

    Hi all,
    I have to give support to this new client of ours and the system out there was a real mess.The log files for all four databases were ranging from 5 to 9 GB's, no maintanance no nothing was done since the setup of the system. I have truncated the logs after taking proper backups since it all started after they compalined a DTS was not working, which was due to no disk space available .
    Now I have to shift the log files to a seperate disk.
    I know it can be done by detaching the database and attaching it back, I was wondering if we can do it without bringing the system offline?
    Anycomments welcome.
    Thankyou.
    regards,
    harshal.

  2. #2
    Join Date
    Jul 2002
    Location
    Village, MD
    Posts
    621
    Backup db and restore it like this one:

    RESTORE DATABASE testDB
    FROM disk='f:\testDB.bak'
    WITH RECOVERY,REPLACE,
    MOVE 'testDBLog' TO 'F:\testDB.LDF'

Posting Permissions

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