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 ?
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.