How to export Sql Server 2014 installation parameters?

%3CLINGO-SUB%20id%3D%22lingo-sub-1533739%22%20slang%3D%22en-US%22%3EHow%20to%20export%20Sql%20Server%202014%20installation%20parameters%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1533739%22%20slang%3D%22en-US%22%3E%3CP%3EHey%20guys%2C%20this%20is%20my%20first%20conversation%20in%20the%20community.%20I%20hope%20to%20be%20clear%20about%20my%20question.%20So%2C%20I%20just%20want%20to%20know%20if%20I%20can%20export%20the%20settings%20from%20Sql%20Server%202014%2C%20to%20install%20again%20using%20just%20the%20command%20prompt.%20Does%20anyone%20know%20if%20I%20can%2C%20if%20I%20can%20how%3F%3CBR%20%2F%3EI%20want%20to%20use%20like%20this%3A%3CBR%20%2F%3E%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fsql%2Fdatabase-engine%2Finstall-windows%2Finstall-sql-server-from-the-command-prompt%3Fview%3Dsql-server-ver15%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Ehttps%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fsql%2Fdatabase-engine%2Finstall-windows%2Finstall-sql-server-from-the-command-prompt%3Fview%3Dsql-server-ver15%3C%2FA%3E%3CBR%20%2F%3EThanks%20for%20so%20far!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1535242%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20export%20Sql%20Server%202014%20installation%20parameters%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1535242%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F734113%22%20target%3D%22_blank%22%3E%40Chrcastilho%3C%2FA%3E%26nbsp%3BOne%20can%20install%20SQL%20server%20from%20command%20prompt%2C%20if%20you%20know%20the%20exact%20parameters%20you%20want%20to%20install%20with.%20such%20as%20the%20server%20engine%2C%20Analysis%20service%20etc.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EYou%20can%20also%20copy%20the%20configuration%20file%20that%20will%20keep%20the%20settings%20of%20the%20previously%20installed%20server%2C%20this%20can%20also%20be%20used%20to%20deploy%20the%20server%20with%20the%20exact%20same%20settings.%20You%20can%20find%20more%20information%20about%20this%20here%20%26gt%3B%26gt%3B%26gt%3B%3C%2FP%3E%3CP%3E%3CA%20title%3D%22Sql-Server%20configurations%20details%22%20href%3D%22https%3A%2F%2Fwww.sqlservercentral.com%2Fblogs%2Fsql-server-configuration-files%26nbsp%3B%22%20target%3D%22_self%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fwww.sqlservercentral.com%2Fblogs%2Fsql-server-configuration-files%26nbsp%3B%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CA%20title%3D%22Microsoft%20configurations%20File%22%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fsql%2Fdatabase-engine%2Finstall-windows%2Finstall-sql-server-using-a-configuration-file%3Fview%3Dsql-server-ver15%22%20target%3D%22_self%22%20rel%3D%22noopener%20noreferrer%22%3Ehttps%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fsql%2Fdatabase-engine%2Finstall-windows%2Finstall-sql-server-using-a-configuration-file%3Fview%3Dsql-server-ver15%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ei%20hope%20this%20helps.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1535261%22%20slang%3D%22en-US%22%3ERE%3A%20How%20to%20export%20Sql%20Server%202014%20installation%20parameters%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1535261%22%20slang%3D%22en-US%22%3EHi%20Christian%2C%20Yes%2C%20you%20can%20exports%20the%20settings%20of%20already%20installed%20instance.%20you%20can%20query%20sys.configurations%20to%20capture%20the%20current%20configuration%20parameters%2Fvalues.%20But%20if%20your%20question%20is%20about%20if%20you%20can%20use%20command%20prompt%20to%20install%20sql%20server.%20The%20answer%20is%20yes%2C%20you%20can%20refer%20to%20%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fsql%2Fdatabase-engine%2Finstall-windows%2Finstall-sql-server-from-the-command-prompt%3Fview%3Dsql-server-ver15%23%3A~%3Atext%3D%2520Install%2520SQL%2520Server%2520from%2520the%2520Command%2520Prompt%2CRequired%2520to...%25205%2520See%2520Also.%2520%2520More%2520%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Ehttps%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fsql%2Fdatabase-engine%2Finstall-windows%2Finstall-sql-server-from-the-command-prompt%3Fview%3Dsql-server-ver15%23%3A~%3Atext%3D%2520Install%2520SQL%2520Server%2520from%2520the%2520Command%2520Prompt%2CRequired%2520to...%25205%2520See%2520Also.%2520%2520More%2520%3C%2FA%3E%20Thanks%20Hemantgiri%20Goswami%3C%2FLINGO-BODY%3E
Occasional Visitor

Hey guys, this is my first conversation in the community. I hope to be clear about my question. So, I just want to know if I can export the settings from Sql Server 2014, to install again using just the command prompt. Does anyone know if I can, if I can how?
I want to use like this:
https://docs.microsoft.com/en-us/sql/database-engine/install-windows/install-sql-server-from-the-com...
Thanks for so far!

2 Replies

@Chrcastilho One can install SQL server from command prompt, if you know the exact parameters you want to install with. such as the server engine, Analysis service etc.

 

You can also copy the configuration file that will keep the settings of the previously installed server, this can also be used to deploy the server with the exact same settings. You can find more information about this here >>>

https://www.sqlservercentral.com/blogs/sql-server-configuration-files  

https://docs.microsoft.com/en-us/sql/database-engine/install-windows/install-sql-server-using-a-conf... 

 

i hope this helps.

Hi Christian, Yes, you can exports the settings of already installed instance. you can query sys.configurations to capture the current configuration parameters/values. But if your question is about if you can use command prompt to install sql server. The answer is yes, you can refer to https://docs.microsoft.com/en-us/sql/database-engine/install-windows/install-sql-server-from-the-com... Thanks Hemantgiri Goswami