August 25, 2020 at 1:52 pm
Hi,
I have to install the sql 2016 on new server. I want to copy the same settings and directory structure of an other instance, so maybe for directory structure I need to create folders which I can do in specific drive ( Not C 🙂
Also, I want to keep the same configuration or settings of an other instance which is also running 2016 version.
How can I copy or know which service components were installed on prior installation. The idea is installation needs to be same as the one which is already running on other server. Do I have to look at configuration manager to see what services are installed? How to check if Analysis services or client tool connectivity is installed as well?
August 25, 2020 at 5:50 pm
you can re-run setup, and check the "add features" checkbox to see what's installed.
For settings, you can get sp_configure and some other settings, but this might help: https://www.red-gate.com/simple-talk/sql/sql-training/how-to-document-and-configure-sql-server-instance-settings/
Can I ask why you want everything duplicated? Is the hardware the same?
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply