Downloaded 31 times
Uploaded byTanawit Chansuchai
SQL Backup trough Veeam *AND* SQL
- Veeam provides hyper-availability solutions to back up any application, data across any cloud including physical, public, private, and edge environments. - It offers high-speed recovery of VMs and files within 15 minutes through instant VM recovery, migration, and granular file-level recovery capabilities. - Veeam uses Microsoft VSS for consistent image-based backups of SQL Server instances and databases, and provides SQL log backups and exploration tools for restore and export of SQL data. - It enables disaster recovery of workloads to Microsoft Azure through direct restore of backups to provision VMs in Azure, helping maintain business continuity.
In this document
Powered by AI
Tanawit Chansuchai introduces Veeam and its Hyper-Availability solutions for backing up SQL through various cloud environments.
Overview of the Veeam platform covering Physical, Public Cloud, SaaS, Managed Cloud, Private Cloud, and Edge/IoT backups.
Discusses agentless protection for ensuring the availability of the Always-On Enterprise.
High-speed recovery mentioned includes instant VM recovery and granular file level recovery.
Replication and backup strategies including offsite backups and the 3-2-1 rule for data protection.
Utilization of SureBackup and On-Demand Sandbox for VM verification and leveraging data.
Creating and scheduling automated reports for disaster recovery, including testing updates and training IT staff.
Overview of SQL Server architecture and primary tools used for database management and interaction.
Information on data/log file management, Microsoft VSS for backups, and using Veeam for SQL Server restore options.
Settings for Veeam SQL backup jobs, log backup frequency, and resource considerations.
Implementation of disaster recovery as a service to Azure, including configurations for site-to-site VPNs. Enhancing business continuity with metrics on speed, failures, and direct restoration capabilities.
Presentation concludes with a thank you and sharing contact information.
SQL Backup trough Veeam *AND* SQL
- 1. Tanawit Chansuchai System Engineer,Thailand Tanawit.chansuchai@veeam.com SQL Backups trough Veeam *AND* SQL Any App, Any Data , Across any Cloud The Hyper-Availability solutions
- 2.
- 3. Veeam Hyper-Availability Platform Physical Public Cloud SaaSManaged Cloud Private Cloud Edge/ IoT Any data,any app, across any cloud. Universal APIs Veeam Backup & Replication Veeam ONE Backup for Office 365 Availability for AWS Agents for Windows & Linux
- 4. Availability for TheAlways-ON Enterprise Agentless protection
- 5. High-speed Recovery instant VMrecovery vPower migrate online
- 6. High-speed Recovery RTO< 15 Minutes! Granular File level Recovery
- 7. High-speed Recovery RTO< 15 Minutes! Application File Level Recovery
- 8. Veeam Explorer forStorage Snapshots Restore VM / File / Mailbox from Storage Snapshots
- 9. Data Loss Avoidance ReplicationBackup file to offsite Create Backup Job Create Backup copy Job
- 10. Hyper-converge System Data LossAvoidance 3-2-1 Rule with Veeam Hyper-converge System Host-based replication Assisted failover Real failback
- 11. Verified Protection &Leveraged Data SureBackup & On Demand Sandbox
- 12. Host-based Replication Verified Protection &Leverage Data SureReplica & On Demand Sandbox VM Verification job OS Report App
- 13. Disaster Recovery Plan SureReplica report You can schedule automatic report delivery for result of sure replica, you can to receive report by email, Note that you can schedule report after sure replica job done.
- 14.
- 15. NAT SWITCH • Testupdate patch • Troubleshoot issues • Train IT Staff • Provision dev application Verified Protection & Leverage Data SureReplica & On Demand Sandbox
- 16.
- 17. SQL Server architecturebasics • Database Server – Windows machine with one or more SQL Instances installed • There may be multiple SQL Instances on a single Windows server • Every SQL Server Instance is represented by a Windows Service • Every SQL Server instance can have multiple Databases
- 18. Databases Database is justa set of files until it’s attached to a SQL instance. SQL Server provides SQL/T-SQL to interact with databases. Main tools that DBAs and database users work with: -SQL Server Management Studio - SQL Log files -sqlcmd SELECT first_name, last_name FROM people WHERE hair_color = "red"
- 19. Data and Logfiles Every database always has at least one data file (.MDF) and one log file (.LDF) It’s a good idea to put data and log files on separate disks for maximizing I/O performance. .MDF _log.LDF
- 20. Microsoft VSS andSQL • VSS is a Windows subsystem that allows for consistent online backups Windows App App SQL VSS VSS Provider 1 2 3 4 5
- 21. VEEAM, Microsoft VSSand SQL • Veeam Backup & Replication use VSS for consistent Image- based backups. Windows App App SQL VSS VSS Provider 1 2 3 4 5
- 22. Veeam Explorer forSQL Server Support for Point in time restore and restore to a specific transaction Easy way to restore or export SQL databases • To original location • To any other SQL server (also physical) • As a set of database files to any location of your choosing
- 23. Veeam backup jobsettings - Default option is to truncate the logs. - Make sure it’s what you need. - Logs are backed up to a ‘nul’ location to force truncation
- 24. Veeam SQL LogBackups - Only for databases in full and bulk-logged recovery models - Set up interval to meet you RPO/RTOs - Per VM
- 25. Veeam SQL LogBackups • Frequent log backups require some resources, so make sure to test your settings.
- 26. Disaster Recovery as aService SQL SERVER to The Azure (Public)
- 28. Veeam PN forMicrosoft Azure
- 29. Veeam PN forMicrosoft Azure • Main Office • Home Office • Temporary Office • On the road travelling It gives users a holistic, site-to-site and point-to-site networking solution that is designed to keep employees connected and Always-On, regardless of their location
- 30. Veeam PN forMicrosoft Azure Site to Site VPN
- 31. Veeam PN forMicrosoft Azure Point to Site VPN
- 32. Non-Stop Business Continuity 2.5 xless Failures 3 x more Speed 91% SLA Direct Restore To Azure
- 33. Provisioning of VMfrom Azure Marketplace available today Veeam VMs are BYOL (Bring Your Own License) VMs in the Azure Marketplace VCC for the Enterprise Veeam Virtual Machine VCC for Service Providers Veeam Virtual Machine Direct Restore to Microsoft Azure Veeam Virtual Machine Managed Backup Portal Veeam Virtual Machine Veeam PN for Microsoft Azure Veeam Virtual Machine
- 34. Direct Restore toMicrosoft Azure Veeam Backup & Replication™ - Veeam Direct Restore to Microsoft Azure Veeam Backup Free Edition Veeam Endpoint Backup™ Any backups stored in a Veeam repository… …can be restored to Azure using the VBR UI. Gateway Server (optional) • Quickly restore Windows and Linux-based VMs, physical servers or endpoints to Azure to minimize business disruption • Execute planned workload migrations from on site to the cloud to reduce on-site resource constraints • Easily create an Azure-based test environment for testing backup reliability, as well as patches and critical updates to mitigate risks associated with application deployment
- 35. On-demand Disaster Recoveryin Microsoft Azure using Veeam animated Veeam Backup Repository Object Storage Azure OFFSITE-DATA Veeam Direct Restore Failed workloads Restore As Azure VMs Veeam PNVeeam PN Market place Azure Proxy 192.168.1.x/24 172.168.11.x/24
- 36.
- 37. Thank you Tanawit chansuchai,++66 909 615 246 www.veeam.com http://era-cloud.blogspot.com/