Moving the existing SQL Server data files and user databases
After completing the SQL installation and configuration on the additional nodes, move the existing standalone SQL Server data files and user databases from the local drive to the shared drives to ensure proper failover operations in the cluster. Complete the following tasks to move the databases:
-
From the SQL Server Service Manager, stop the SQL Server service.
-
Verify that you have backed up your existing data.
-
Import the volumes or LUNs to the node where the original files are located on the local drives and mount the volumes (add drive letters).
-
Move the SQL Server data files and user databases to the shared volumes or LUNs. Follow the procedures described in Microsoft Knowledge Base Article - 224071: INF: Moving SQL Server databases to a New Location with Detach/Attach.
Refer to: default.aspx?scid=kb;en-us;224071.
-
Restart SQL Server.
More Information
Connecting virtual disks to the cluster node
Related information