[POWERSHELL] 如何远端使用SQLPS模组备份SQL 2008 R2资料库

环境:

Client : Win 2012 R2 安装 SQL 2014 Feature Fack , 已安装SQLPS

Server: SQL 2008 R2 , Instance 为预设安装

需求:

要从Client 端远端执行SQLPS ,备份Server 端资料库

Code:

$server = 'X.X.X.X\MSSQLSERVER'   #预设安装$db = 'test'$username = 'sa'$password = 'xxxxxxxxxx'$password = ConvertTo-SecureString -AsPlainText $password -Force$cred = New-Object System.Management.Automation.PSCredential -ArgumentList $username,$passwordBackup-SqlDatabase -ServerInstance $server -Database $db -BackupFile "D:\test.bak" -Credential $cred

Problem

执行就会报错:

Backup-SqlDatabase :  无法连接伺服器  X.X.X.X\MSSQLSERVERD:\Source\backupSql.ps1:8 ??:1+ Backup-SqlDatabase -ServerInstance $server -Database $db -BackupFile "D:\test.ba ...+ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~    + CategoryInfo          : NotSpecified: (:) [Backup-SqlDatabase], ConnectionFailureException    + FullyQualifiedErrorId : Microsoft.SqlServer.Management.Common.ConnectionFailureException,Microsoft.SqlServer.Management.PowerShell.Backup   SqlDatabaseCommand

请问有人知道问题在哪吗 ?

谢谢^^