Scenario: A given SQL server has all data and log files on an external disc array (including master and msdb data and log files). The server fails. A new server is stood up, and the external array is connected to it. How is SQL installed to point to the existing master and msdb files??
What are the disadvantages of setting it up this way?
Could / Should SQLs other internal files be installed on the external array as well (i.e. none of SQL on the C drive but all external)??
All help is greatly appreciated.
Thank You
Rollin Burr
Politicians and diapers have one thing in common. They should both be changed regularly, and for the same reason.