用于将SQL Server数据库从一台服务器恢复到另一台具有不同驱动器的服务器的PowerShell脚本

# 导入SQL Server模块
Import-Module SQLPS -DisableNameChecking

# 设置源服务器和目标服务器的连接信息
$sourceServer = "源服务器名称"
$sourceDatabase = "源数据库名称"
$sourceUsername = "源服务器用户名"
$sourcePassword = "源服务器密码"

$targetServer = "目标服务器名称"
$targetDatabase = "目标数据库名称"
$targetUsername = "目标服务器用户名"
$targetPassword = "目标服务器密码"

# 创建目标数据库
New-Item -Path "SQLSERVER:\SQL\$targetServer\DEFAULT\Databases" -Name $targetDatabase -ItemType "Directory"

# 备份源数据库
Backup-SqlDatabase -ServerInstance $sourceServer -Database $sourceDatabase -BackupFile "C:\Temp\$sourceDatabase.bak"

# 恢复源数据库到目标服务器
Restore-SqlDatabase -ServerInstance $targetServer -Database $targetDatabase -BackupFile "C:\Temp\$sourceDatabase.bak" -ReplaceDatabase `
    -Credential (Get-Credential -UserName $targetUsername -Password $targetPassword)

# 清理临时备份文件
Remove-Item -Path "C:\Temp\$sourceDatabase.bak"