Need to create a new instance of a SQL db with a unique port
by jgavin65 at 2012-10-11 06:47:47
I need to create a new instance of a SQL db with a unique port and service account specific permissions. I suspect this has already been done before but having a time finding one.
I'm relatively new to PS and it's a great tool to have in my toolbox!
Many thanks in advance!
by Klaas at 2012-10-11 09:10:30
a command line install works in Powershell as in cmd.exe:
I use a .ps1 script file where the command is constructed by concatenating all parts and a .txt config file with the needed parameters, from MAK & Yan Pan's book 'Administering SQl Server 2008 with Windows Powershell"(Wrox 2009). It's a Powershell V 1 script with SQl 2008, though.
You must be logged in to reply to this topic.