backup SQL server configuration


any one tried to copy/backup the configuration of MS SQL server and then copy to the target DR SQL server and then setup the Log shipping before  ?

is it possible ?
marrowyungSenior Technical architecture (Data)Asked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Kini pradeepDevelopment ManagerCommented:
why do you  need SQL server configuration ?
if you need to setup a DR for SQL server , Backup restore the DB that you want and then enable log shipping.

should be of help
marrowyungSenior Technical architecture (Data)Author Commented:
I mean SQL server configuration.
Vitor MontalvãoMSSQL Senior EngineerCommented:
SQL Server configuration information are stored in master database but it will be a catastrophe if you copy everything. What kind of configuration information that you need?
The 7 Worst Nightmares of a Sysadmin

Fear not! To defend your business’ IT systems we’re going to shine a light on the seven most sinister terrors that haunt sysadmins. That way you can be sure there’s nothing in your stack waiting to go bump in the night.

marrowyungSenior Technical architecture (Data)Author Commented:
I want to quickly setup another SQL server without copy and paste all existing setting .
Vitor MontalvãoMSSQL Senior EngineerCommented:
I guess it will take more time as you might for sure stated by now.
What you can do is when setting up the next SQL Server instance, is to save the setup configuration file so it can be used for the next SQL Server installations.
marrowyungSenior Technical architecture (Data)Author Commented:
"What you can do is when setting up the next SQL Server instance, is to save the setup configuration file so it can be used for the next SQL Server installations."

as long as I can remember this is what the only thing i can thing of, so other than this, nothing we can do AFTER SQL server setup  ?
Vitor MontalvãoMSSQL Senior EngineerCommented:
You can still get the configuration file from the old installed SQL Server instances. Each SQL Server installation generates a configurationFile.ini file. Use that one from the source SQL Server instance that you want to get the configurations from.
Example from my local SQL Server installation: C:\Program Files\Microsoft SQL Server\140\Setup Bootstrap\Log\20170830_095722\ConfigurationFile.ini
marrowyungSenior Technical architecture (Data)Author Commented:
tks. but that file can ONLY be used during MS SQL installation, but not after the installation, right?
Vitor MontalvãoMSSQL Senior EngineerCommented:
When installing an new SQL Server instance you can provide the configuration file. It's in the MSDN article I've posted few comments above:
Setup.exe /ConfigurationFile=MyConfigurationFile.INI

Open in new window

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
marrowyungSenior Technical architecture (Data)Author Commented:
yeah, the only way ! not AFTER that.
marrowyungSenior Technical architecture (Data)Author Commented:
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today

From novice to tech pro — start learning today.