Results 1 to 3 of 3
  1. #1
    Join Date
    Dec 2004

    Unanswered: Changing path of data & log files on the fly

    We have a SQL Server setup as a publisher to 15 subscribers. We need to change the path of the data & log files to a new drive (added a new harddisk). We plan to take a cold backup of the database and shift the data & log files to the new drive. Then we just attach the data & log files from the new path.

    Will this disturb my existing replication Setup?
    Is the the correct procedure for changing the path of the existing data & log files?
    What is the appropriate method for shifting data & log file of a live database to a different location (directory/drive) ?

    thanks in advance

  2. #2
    Join Date
    Jul 2003
    San Antonio, TX
    disable replication;
    move files to new location;
    enable replication.
    "The data in a record depends on the Key to the record, the Whole Key, and
    nothing but the Key, so help me Codd."

  3. #3
    Join Date
    Dec 2004
    Thanks for the suggestion. I'll try this out and confirm back. Thanks again anyways.

Posting Permissions

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