Windows Server Backup和SQL Server 2012 [英] Windows Server Backup and SQL Server 2012

问题描述

我们在Windows Server 2012 R2上安装了带有SQL Server 2012的hyper-v虚拟机。这台机器有3个虚拟磁盘：1 - 系统，2 - 数据库，3 - 日志。


Windows Server备份是否正确备份具有多个虚拟磁盘的SQL Server？

在虚拟机恢复后，是否会保留数据的完整性？

使用Powershell脚本运行备份：

 $ pol = New-WBPolicy 
 $ VM = Get-WBVirtualMachine |其中vmname -like" SQL" 
 Add-WBVirtualMachine -Policy $ pol -VirtualMachine $ VM 
 Add-WBBackupTarget -Policy $ pol -Target（New-WBBackupTarget -NetworkPath $ uncPathBackup）
 Set-WBVSSBackupOptions -Policy $ pol -VssCopyBackup 
 Start-WBBackup -Policy $ pol 

THX

解决方案

更好地运行SQL Server本机备份，它更安全

Hi,
We have hyper-v virtual machine with installed SQL Server 2012 on Windows Server 2012 R2. This machine has 3 virtual disk: 1 - System, 2 - Database, 3 - Logs.
Is Windows Server Backup correct backup SQL Server with multiple virtual disk ?
Will the integrity of the data be retained after the virtual machine has been restored?

Backup is run with Powershell script:

 $pol = New-WBPolicy
 $VM = Get-WBVirtualMachine | where vmname -like "SQL"     
 Add-WBVirtualMachine -Policy $pol -VirtualMachine $VM
 Add-WBBackupTarget -Policy $pol -Target (New-WBBackupTarget -NetworkPath $uncPathBackup)   
 Set-WBVSSBackupOptions -Policy $pol -VssCopyBackup      
 Start-WBBackup -Policy $pol         

THX

解决方案

Better run SQL Server native backup, it's more safe.

这篇关于Windows Server Backup和SQL Server 2012的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！