zzzzzxx Contributor.
Contributor.
69 views

Backing up SQL server vm best practices

We have a very large and very busy SQL server. It appears that when backing up the whole VM it takes quite a bit of time! We are talking a few TBs. I have noticed that the snapshot grows so large from the backup, that it has trouble removing it after the backup. Is there a better method for this. Perhaps a filesystem backup on a VM? Whats the best method for a large SQL server?

 

 

0 Likes
1 Reply
Highlighted
Knowledge Partner Knowledge Partner
Knowledge Partner

Re: Backing up SQL server vm best practices

Hello @zzzzzxx,

You should look into the MSSQL integration module which works great. It also offers more granular restore capabilities and high performance backup.

https://docs.microfocus.com/itom/Data_Protector:2019.05/MSSQLServerIntegration
https://www.data-protector.org/wordpress/2018/06/optimize-mssql-backup-performance/

Using VEPA for the DR part (OS disks) and the MSSQL integration for the database is valid concept.

Regards,
Sebastian Koehler

---
Please use the Like button below, if you find this post useful.
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.