<div>
Why don't you do a here-string? 
 

<pre><code class="code-1 nolinks" id="code-20-41481230-1">$dbCommand = @&quot;
RESTORE DATABASE [MS]
FROM DISK = 'C:\dean\northwind.bak'
MOVE 'Northwind' TO 'C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\MS.MDF'
MOVE 'Northwind_log' TO 'C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\MS_1.ldf'
NOUNLOAD, STATS = 10
&quot;@
</code></pre>
</div>

<div>
Hi Bob, 
 
Because I am new to Powershell and didnt know what a here-string is? Was just following an example I saw online 
 
Thanks, 
Dean
</div>

<div>
How do I run that in a Powershell ISE window Bob?
</div>

<div>
Try it and see if it does what you want. &nbsp;It's definitely cleaner than all that concatenation.
</div>

<div>
So I need to remove it from the function correct?
</div>

<div>
Qlemo, I used your second code snippet and got.... 
 
PS C:\Windows\system32&gt; RestoreDB 
Msg 102, Level 15, State 1, Server MANGANMSS-L-007, Line 3 
Incorrect syntax near 'MOVE'.
</div>

<div>
On another note, it is usually better to use the .NET means in PowerShell instead of commandline tools like OSQL or SQLCMD, In particular since you are able to check for errors, evaluate results aso.
</div>

<div>
Try again, we might have crossed posting, while I edited my comment to include the correction ...
</div>

<div>
That worked a treat now. I know this is probably a stupid question but how can I use the .net means, rather than command line?
</div>

<div>
It is indeed more &quot;complex&quot;. Best to show a complete example containing Select, Update and Insert, with parameter binding (so you do not have to &quot;inject&quot; data into the SQL directly): 

<pre><code class="code-10 nolinks" id="code-20-41481361-1">&lt;# Table created with:
create table ADUsers (
 MISGUID varchar(35),
 SID varchar(35),
 FirstName varchar(40),
 LastName varchar(40)
)
#&gt;

cls

$sqlCmd = 'select * from ADUsers'
$constr = 'Server=mssqlserver\mssql2008; Database=Coko; Integrated Security=true'

$con = New-Object Data.SqlClient.SqlConnection ($constr)
$da = New-Object Data.SqlClient.SqlDataAdapter ($sqlCmd, $constr)
$dt = New-Object Data.DataTable
$da.Fill($dt) | out-null 

$cmd = New-Object Data.SqlClient.SqlCommand ('update ADUsers set SID = @SID where MISGUID = @MISGUID', $con)
$cmd.Parameters.Add('@MISGUID', 'varchar', 35, 'MISGUID') | out-null
$cmd.Parameters.Add('@SID' , 'varchar', 35, 'SID' ) | out-null
$da.UpdateCommand = $cmd

$cmd = New-Object Data.SqlClient.SqlCommand (@'
insert into ADUsers ( MISGUID, SID, FirstName, LastName) 
 values (@MISGUID, @SID, @FirstName, @LastName) 
'@, $con)
$cmd.Parameters.Add('@MISGUID' , 'varchar', 35, 'MISGUID' ) | out-null
$cmd.Parameters.Add('@SID' , 'varchar', 35, 'SID' ) | out-null
$cmd.Parameters.Add('@FirstName', 'varchar', 40, 'FirstName') | out-null
$cmd.Parameters.Add('@LastName' , 'varchar', 40, 'LastName' ) | out-null
$da.InsertCommand = $cmd

$row = $dt.NewRow()
$row['MISGUID' ] = 'FirstGUID'
$row['SID' ] = 'FirstSID'
$row['FirstName'] = 'First'
$row['LastName' ] = 'Name'
$dt.Rows.Add($row)

$dt.Rows | ft -auto
$dt.Rows[0].SID = 'exampleSID'
$dt.Rows | ft -auto
$da.Update($dt)
</code></pre>
</div>

<div>
Wow that's a great example. Thanks very much. I may need to post further questions regarding remote connections and moving files across networks.
</div>

<div>
Be sure to start a new thread for each topic so these don't meander on forever.
</div>

<div>
<div class="content wysiwyg-content">
Hi All, 
 
Can anyone spot the problem with this.... 

<pre><code class="code-10 nolinks" id="code-10-28928948-1">function global:RestoreDB 
{
 [string] $dbCommand = &quot;RESTORE DATABASE [MS] &quot; +
 &quot;FROM DISK = 'C:\dean\northwind.bak' &quot; +
 &quot;MOVE 'Northwind' TO 'C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\MS.MDF', &quot; +
 &quot;MOVE 'Northwind_log' TO 'C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\MS_1.ldf',&quot; +
 &quot;NOUNLOAD, STATS = 10&quot;
 
 OSQL.EXE -E -Q $dbCommand
}
</code></pre>
 
Error Message: 
 
PS C:\Windows\system32&gt; RestoreDB 
Msg 102, Level 15, State 1, Server Main007, Line 1 
Incorrect syntax near 'MOVE'. 
 
Many Thanks, 
Dean
</div>
</div>

Hi All,

Can anyone spot the problem with this....
(CODE)

Error Message:

PS C:\Windows\system32> RestoreDB
Msg 102, Level 15, State 1, Server Main007, Line 1
Incorrect syntax near 'MOVE'.

Many Thanks,
Dean

PowerShell code error

Windows PowerShell is a task automation and configuration management framework from Microsoft, consisting of a command-line shell and associated scripting language built on the .NET Framework. PowerShell provides full access to the Component Object Model (COM) and Windows Management Instrumentation (WMI), enabling administrators to perform administrative tasks on both local and remote Windows systems as well as WS-Management and Common Information Model (CIM) enabling management of remote Linux systems and network devices.

Powershell

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.