Categories
Software

SQL Server backup with PowerShell

Create a copy-only backup from PowerShell:

Backup-SqlDatabase -ServerInstance 'SalesServer' -Database 'Sales' -BackupFile 'E:\BAK\Sales_Copy.bak' -CopyOnly