marrowyung
asked on
export all SQL server setup configuration to a new SQL server
Dear all,
as I am going to setup a new bunches of new SQL server and we can copy the same configuration from one of the existing SQL server, any way to export and import such kind of configuation from existing SQL server?
as I am going to setup a new bunches of new SQL server and we can copy the same configuration from one of the existing SQL server, any way to export and import such kind of configuation from existing SQL server?
You have to update it manually using sp_configure system stored procedure.
ASKER
what is that mean ? I don't understand, so can't directly export configuration and import it to another SQL server ? so we have copy the setting manually ?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
how about I already go through installation wizard as I cant' wait for your answer, anyway to import the setting after the installation wizard ? I am now installing the SP2
The above link is explaining the way to create a configuration file and use it in other installation.
ASKER
I mean before you reply that I already finish installing the rest ! so I don't use that configuration INI file to install it at all ! but a lot of configuration like tempdb configuration, to the new installed SQL server DB.
is it possible to generate the configuration from existing SQL server to the new installed SQL server which is INSTALLED ?
is it possible to generate the configuration from existing SQL server to the new installed SQL server which is INSTALLED ?
Yes, you can copy it from here
C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\<installatio nData>\Con figuration File.ini
100 for (SQL2008) and 110 for SQL2012.
C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\<installatio
100 for (SQL2008) and 110 for SQL2012.
ASKER
"Yes, you can copy it from here "
where I copy it to and how can I apply it AFTER I INSTALL the SQL server 2008 R2 ?
where I copy it to and how can I apply it AFTER I INSTALL the SQL server 2008 R2 ?
Configurationfile.ini can be used only during installation not after installation. This is only for setting up the dataabse default If you are taking about post installation configuration then you have to
1.execute SP_configure and check the value in result .
Or
2. select * from sys.configurations
For eg: You want to enable "allow updates" confoguration option in this case you have to run
Sp_configure "allow updates" , 1
go
Reconfigure
This is the manual process or you can make a script manually and execute it on all instances.
1.execute SP_configure and check the value in result .
Or
2. select * from sys.configurations
For eg: You want to enable "allow updates" confoguration option in this case you have to run
Sp_configure "allow updates" , 1
go
Reconfigure
This is the manual process or you can make a script manually and execute it on all instances.
ASKER
wait, what is "allow updates" configuration for ?
"Configurationfile.ini can be used only during installation not after installation. This is only for setting up the dataabse default If you are taking about post installation configuration then you have to "
that's what I am worrying about !
"1.execute SP_configure and check the value in result .
Or
2. select * from sys.configurations
"
you mean once run this, copy the setting one by one ?
"Configurationfile.ini can be used only during installation not after installation. This is only for setting up the dataabse default If you are taking about post installation configuration then you have to "
that's what I am worrying about !
"1.execute SP_configure and check the value in result .
Or
2. select * from sys.configurations
"
you mean once run this, copy the setting one by one ?
Which kind of configuration do you wish to be set in all SQL Server?
Usually we have a setup configuration that is used to install all SQL Server instances but then each instance has their own resource configuration (CPU, Memory, disk, MAXDOP, ...) depending on the databases that will be stored.
Usually we have a setup configuration that is used to install all SQL Server instances but then each instance has their own resource configuration (CPU, Memory, disk, MAXDOP, ...) depending on the databases that will be stored.
ASKER
oh, I have gave a task to install SQL server and the configuration will be the same as one of the SQL server, which serve the same purpose.
as I need to export all configuration except server name from this server to all SQL server I am going to install.
as I need to export all configuration except server name from this server to all SQL server I am going to install.
"as I need to export all configuration except server name from this server to all SQL server I am going to install."
Please define ALL CONFIGURATION
Please define ALL CONFIGURATION
ASKER
oh, yeah. it is hard to define now .
ASKER
hi,
I have a plan on DR drill:
https://www.experts-exchange.com/questions/29207537/DR-drill-of-SQL-server.html
so is it says that this should works:
https://serverfault.com/questions/988391/copying-sql-server-settings-to-new-server
https://dbatools.io/? any tools from https://dbatools.io/ can help on that?
I see from this page:
https://dbatools.io/configuration/
Some dbatools functionality that has not been talked about much on the blog are our internal configuration options. This functionality was added back in October 2017. Kind of like how in ADS or SSMS, you can go to File -> Preferences -> Settings or Edit -> Preferences to edit advanced preferences and options, you can do something similar in dbatools!
Since dbatools is command-line based, you can view/modify your current options using our various config commands.
is this one:
I have a plan on DR drill:
https://www.experts-exchange.com/questions/29207537/DR-drill-of-SQL-server.html
so is it says that this should works:
https://serverfault.com/questions/988391/copying-sql-server-settings-to-new-server
https://dbatools.io/? any tools from https://dbatools.io/ can help on that?
I see from this page:
https://dbatools.io/configuration/
dbatools advanced configuration
POSTED ON AUGUST 20, 2019 BY CLAUDIO SILVASome dbatools functionality that has not been talked about much on the blog are our internal configuration options. This functionality was added back in October 2017. Kind of like how in ADS or SSMS, you can go to File -> Preferences -> Settings or Edit -> Preferences to edit advanced preferences and options, you can do something similar in dbatools!
Since dbatools is command-line based, you can view/modify your current options using our various config commands.
- Get-DbatoolsConfig
- Get-DbatoolsConfigValue
- Set-DbatoolsConfig
- Reset-DbatoolsConfig
- Import-DbatoolsConfig
- Export-DbatoolsConfig
- Register-DbatoolsConfig
- Unregister-DbatoolsConfig
is this one:
- Import-DbatoolsConfig
- Export-DbatoolsConfig
ASKER
http://stackoverflow.com/questions/5586811/sql-server-management-studio-where-is-tools-import-and-export-settings-menu
?