marrowyung
asked on
backup SQL server configuration
hi,
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 ?
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 ?
ASKER
I mean SQL server configuration.
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?
ASKER
I want to quickly setup another SQL server without copy and paste all existing setting .
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.
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.
ASKER
"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 ?
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 ?
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_095 722\Config urationFil e.ini
Example from my local SQL Server installation: C:\Program Files\Microsoft SQL Server\140\Setup Bootstrap\Log\20170830_095
ASKER
tks. but that file can ONLY be used during MS SQL installation, but not after the installation, right?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
yeah, the only way ! not AFTER that.
ASKER
tks.
if you need to setup a DR for SQL server , Backup restore the DB that you want and then enable log shipping.
https://www.mssqltips.com/sqlservertip/2301/step-by-step-sql-server-log-shipping/
should be of help