Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2004
    Location
    Melbourne
    Posts
    144

    Unanswered: SQL Server Cluster

    I've got two SQL Servers in a cluster active\passive mode. i want to change over the file location of the mdf, ndf, ldf files. Would that be moved across to the passive SQL Server automatically or do i have to do a major workaround ?

  2. #2
    Join Date
    Jan 2003
    Location
    Massachusetts
    Posts
    5,800
    Provided Answers: 11
    The database files can only be moved to the shard disk system, which itself is automagically passed between nodes at need. When SQL Server starts up, the master database will be read for the locations of all of the files. When you use sp_attach_db, or restore database, the master database is updated with the new locations of the files.

Posting Permissions

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