This post is more than 5 years old
2 Posts
0
1753
November 11th, 2013 06:00
Backup Virtual SQL Server
Hi,
What's the Best Practices for backup a virtual SQL Server ?
Now I backup one time per day with sql agent and one time per week whit Windows VMware Image.
Image backup is it necessary ?
Avamar version 6.1.101-87
Virtual SQL server : Windows 2008R2
Thanks
Pascal
No Events found!
DELL-Leo
Community Manager
•
8.7K Posts
0
November 12th, 2013 19:00
Hey,
Any best practice depend on your request.
Following docs are for your reference.
EMC Avamar 7.0 for SQL Server
https://support.emc.com/docu48236_Avamar-7.0-for-SQL-Server-User-Guide.pdf?language=en_US
EMC Avamar 7.0 Operational Best Practices
https://support.emc.com/docu48217_Avamar-7.0-Operational-Best-Practices.pdf?language=en_US
Hope this helpful.
J_H_
2 Intern
•
498 Posts
0
November 11th, 2013 08:00
matter of opinion, and what your needs are.
I backup once a week as a VM so we can rebuild the whole VM if needed.
but because I have Large Databases on them and you really cannot restore a database (unless you restore the whole server)
so daily I backup the server as a physical server (excluding the *.ldf and *.mdf) so that I can get the rest of the servers ( never know what a human will decide to keep on the server besides the database).
o17Uu33DCF12520
4 Operator
•
1.1K Posts
0
November 12th, 2013 20:00
suggest you backup all the OS files and SQL SERVER binaries with VMware image backup for a quick restore. make the frequency 1 week if there is no much change on the OS.
also suggest you backup the SQL data files with avamar SQL agent and SQL server itself, because only this way the consistency of the data files can be guaranteed. make the frequency 1 day for data file recovery.