Author Posts

January 1, 2012 at 12:00 am

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.