Now you’re less likely to miss what’s been brewing in our knowledge base with this weekly digest
This section documents how to locate the SQL databases for Veeam products.
SQL Backup files, by default, are not compressed. Even when compression is enabled during the SQL Backup creation, it is not as effective as third-party compression tools.
To save bandwidth, compress SQL Backups using one of the following compression formats before uploading to a support case:
*This PowerShell cmdlet is part of a module installed with SQL and must be run on the SQL server itself. The command will fail if SQL is not installed on the machine where the cmdlet is executed.
Run the following command, filling in SQL connection information and output destination:
Backup-SqlDatabase -ServerInstance "ServerName\InstanceName" -Database "DBName" -BackupFile "C:\Temp\DBBackup_$($env:computername)_$(get-date -f yyyy-MM-dd_HH.mm).bak"
*sqlcmd is an application that is installed with SQL. If SQL is not installed on the machine where the command is executed, sqlcmd will not exist, and the command will fail.
Run the following command, filling in SQL connection information and output destination:
SqlCmd -E -S ServerName\InstanceName -Q "BACKUP DATABASE [DBName] TO DISK='C:\Temp\DBBackupFilename.bak' WITH STATS"
Your feedback has been received and will be reviewed.
Please try again later.
This form is only for KB Feedback/Suggestions, if you need help with the software open a support case
Your feedback has been received and will be reviewed.