Upsert-Server errors

saleyoun@hotmail.com · #1 (**permalink**) October 26th, 2009, 10:00 AM

Can someone help me figure the reason why for the error below.

Quote:

The pipeline has been stopped.
At C:\DBAScripts\Upsert-Server.ps1:35 char:105
+ (Invoke-Sqlcmd -Query "$pSql" -ServerInstance "$pHostName\$pInstanceName,$pTcpPort" -Database master). <<<< Column1
+ CategoryInfo : OperationStopped: (:) [], PipelineStoppedException
+ FullyQualifiedErrorId : PipelineStopped

Split-Path : Cannot find drive. A drive with name 'K' does not exist.
At C:\DBAScripts\Upsert-Server.ps1:310 char:112
+ $strUpsertSql = $strUpsertSql + "'" + (execSQL $sqlNetworkName $instanceName $strQuerySql $tcpPort | Split-Path <<<< -parent) + "', "
+ CategoryInfo : ObjectNotFound: (K:String) [Split-Path], DriveNotFoundException
+ FullyQualifiedErrorId : DriveNotFound,Microsoft.PowerShell.Commands.SplitP athCommand

Here's the result from querying the sysfiles table

Quote:

K:\Program Files\Microsoft SQL Server\MSSQL$HISTORY\data\master.mdf
K:\Program Files\Microsoft SQL Server\MSSQL$HISTORY\data\mastlog.ldf

Here's the result from getStartupParameters function

Quote:

-dK:\Program Files\Microsoft SQL Server\MSSQL$HISTORY\data\master.mdf;
-eK:\Program Files\Microsoft SQL Server\MSSQL$HISTORY\log\ERRORLOG;
-lK:\Program Files\Microsoft SQL Server\MSSQL$HISTORY\data\mastlog.ldf;

The K drive exists on the server.

Need to download code?

Navigation