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!

JoeG
MCITP, MCTS

by Klaas at 2012-10-11 09:10:30

a command line install works in Powershell as in cmd.exe:
http://msdn.microsoft.com/en-us/library/ms144259.aspx

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.