Discussions specific to the VMware vSphere hypervisor
Post Reply
mcgreen1966
Lurker
Posts: 1
Liked: never
Joined: Mar 20, 2018 1:42 pm
Full Name: Mark Green
Contact:

Issues with SQL Server backup and VMDK consolidation

Post by mcgreen1966 » Mar 20, 2018 2:53 pm

Hi just after some advice, our Veeam DB is stored on a separate SQL server, which is currently part of the Vcenter backup group which we use in veeam.
I was thinking this probably wasn't a good idea, as its almost like veeam backing itself up, and i imagine during the snapshot processes there will be loss of connection to the sql server.

To be fair this has been working fine until recently. but the last few weeks, the backups fail, because the SQL server has gone offline, while vcenter is trying to consolidate the snapshots, which takes 6 hours !! (we see in vcenter the message disk consolidation is required).

For ease of restoring services, the team would rather have the whole server backed up using veeam.
my suggestion was to just setup SQL backups jobs, and backup the SQL backup Disk.

which would obviously mean in a DR situation , rebuilding the SQL server from scratch, and restoring the databases.

any advice on why this has started to happen, and the best way forward would be greatly appreciated

Cheers
Mark

veremin
Product Manager
Posts: 16904
Liked: 1440 times
Joined: Oct 26, 2012 3:28 pm
Full Name: Vladimir Eremin
Contact:

Re: Issues with SQL Server backup and VMDK consolidation

Post by veremin » Mar 23, 2018 12:03 pm

Does this SQL server host only VB&R database? If so, why not to leverage configuration backup as backup server protection means?

Post Reply

Who is online

Users browsing this forum: PetrM and 15 guests