Sales Hotline: 1-800-691-1991 8am - 8pm ET
English
White paper

SQL Server Backup and Restore in a Veeam environment

Tibor Karaszi, Consultant, SQL Server expert, MVP

Please rate how helpful this article was to you:
3.6 out of 5 based on 24 ratings
Thank you for helping us improve!
An error occurred during voting. Please try again later.
Published: December, 2018

It’s hard to imagine an infrastructure without an SQL Server installed. Some organizations are fortunate enough to have dedicated an SQL Server database administrator. More often, however, IT admin have to wear multiple hats to manage multiple applications simultaneously. Your approach to SQL Server backup will depend on if your company is DBA-centric or backup-operator-centric in the administration of its SQL Servers.

When you use Veeam to protect your virtualized assets you have two options to back up your SQL Servers. You can use the SQL Server route and generate SQL Server backups into files, which Veeam picks up and stores on a backup server. Another option is to use the Veeam route, where Veeam is used both for the machine backup and also for backup of SQL Server databases.

Read this white paper to learn more about SQL Server backup and learn about:

  • SQL Server backup types, including both the traditional and snapshot-based methods used by third-party, backup solutions like Veeam
  • Identifying the proper Veeam settings for the SQL Server route
  • Performing transaction log backups inside Veeam when using the Veeam route
  • And much more!

It’s hard to imagine an infrastructure without an SQL Server installed. Some organizations are fortunate enough to have dedicated an SQL Server database administrator. More often, however, IT admin have to wear multiple hats to manage multiple applications simultaneously. Your approach to SQL Server backup will depend on if your company is DBA-centric or backup-operator-centric in the administration of its SQL Servers.

When you use Veeam to protect your virtualized assets you have two options to back up your SQL Servers. You can use the SQL Server route and generate SQL Server backups into files, which Veeam picks up and stores on a backup server. Another option is to use the Veeam route, where Veeam is used both for the machine backup and also for backup of SQL Server databases.

Read this white paper to learn more about SQL Server backup and learn about:

  • SQL Server backup types, including both the traditional and snapshot-based methods used by third-party, backup solutions like Veeam
  • Identifying the proper Veeam settings for the SQL Server route
  • Performing transaction log backups inside Veeam when using the Veeam route
  • And much more!
Please rate how helpful this article was to you:
3.6 out of 5 based on 24 ratings
Thank you for helping us improve!
An error occurred during voting. Please try again later.
About the Author