Host-based backup of VMware vSphere VMs.
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 »

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: 20284
Liked: 2258 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 »

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: Google [Bot] and 106 guests