I have a production SQL 2005 server that has no documentation. I need to build an exact replica of this server.
Please see the attached screen shot of the registry settings
You'll notice that there is no MSSQL.1 in the instance names, only MSSQL.2. You should also notice that the SQLDATAROOT key has a value of E:\Program Files\Microsoft SQL Server\MSSQL.1
\MSSQL while the SQLDATA has a value of D:\Program Files\Microsoft SQL Server\MSSQL.2
I don't know how someone has managed to install SQL Database services and have the data path and data root different?
My question is, how is this possible, how would I go about making a new installation look like this, since a new installation always wants to install a new default instance to MSSQL.1. Please note that I have tried to name the instance MSSQL.2 however this is not a valid name.