We are moving our current SQL Cluster Server storage to a new SAN.
After running T-SQL
ALTER DATABASE database_name MODIFY FILE ( NAME = logical_name , FILENAME = 'new_path\os_file_name' )
The path parameters in Sql Configuration must be changed
-dC:\Program Files\Microsoft SQL Server\MSSQL12.MSSQLSERVER\MSSQL\DATA\master.mdf
-lC:\Program Files\Microsoft SQL Server\MSSQL12.MSSQLSERVER\MSSQL\DATA\mastlog.ldf
On a Cluster Sever I see that the SQL Server and Agent are stopped and a Deamon Launcher is running.
What is the correct procedure to change the path parameters in Sql Configuration on a Cluster Server?
Change the path settings in the SQL Server properties / Startup Parameters and then restart the Deamon Launcher?
You put wrong filenames:
Open in new window
Start instance in master-only mode, connect with sqlcmd and use correct commands, e.g.
Open in new window
Commands to start in master only from command prompt:
*Default instance
Open in new window
*Named instace
Open in new window
Cheers,
Daniel