Comprehensive data protection for all workloads
Post Reply
maverick964_uk
Expert
Posts: 102
Liked: 3 times
Joined: May 09, 2013 8:57 am
Full Name: Mike Lavery
Contact:

Veeam SQL DB clean up

Post by maverick964_uk »

We have Veeam 6.5 and it would seem that the SQL database has alot of redundant records to do with user snapshots.
This seems to cause delays with backups...

SQL can be cleaned up directly using native SQL commands however are there Veeam commands that do this?? (via either the GUI or powershell interfaces...)

thanks
foggy
Veeam Software
Posts: 21070
Liked: 2115 times
Joined: Jul 11, 2011 10:22 am
Full Name: Alexander Fogelson
Contact:

Re: Veeam SQL DB clean up

Post by foggy »

Mike, please contact technical support directly to get assistance in cleaning up the database.
Gostev
Chief Product Officer
Posts: 31521
Liked: 6700 times
Joined: Jan 01, 2006 1:01 am
Location: Baar, Switzerland
Contact:

Re: Veeam SQL DB clean up

Post by Gostev »

I also recommend upgrading to the latest version and patch level, as we added many SQL optimization over the last few releases. Thanks!
maverick964_uk
Expert
Posts: 102
Liked: 3 times
Joined: May 09, 2013 8:57 am
Full Name: Mike Lavery
Contact:

Re: Veeam SQL DB clean up

Post by maverick964_uk »

many thanks. We are on 6.5 update3 I believe and will be planning to upgrade to v7.

Does Veeam now manage redundant SQL entries in v7 to do with user snapshots that arent there??
foggy
Veeam Software
Posts: 21070
Liked: 2115 times
Joined: Jul 11, 2011 10:22 am
Full Name: Alexander Fogelson
Contact:

Re: Veeam SQL DB clean up

Post by foggy »

Actually, Veeam B&R v6.5 did also manage them in that way, however there are cases that could result in left-over DB records, such as connection drops, for example.
maverick964_uk
Expert
Posts: 102
Liked: 3 times
Joined: May 09, 2013 8:57 am
Full Name: Mike Lavery
Contact:

Re: Veeam SQL DB clean up

Post by maverick964_uk »

ok so what are the recommended methods to clean up the SQL DB....or are there better features in v7 ?
foggy
Veeam Software
Posts: 21070
Liked: 2115 times
Joined: Jul 11, 2011 10:22 am
Full Name: Alexander Fogelson
Contact:

Re: Veeam SQL DB clean up

Post by foggy » 1 person likes this post

As it was mentioned earlier, the recommended way of addressing such issues is contacting technical support directly.
Post Reply

Who is online

Users browsing this forum: Bing [Bot], Semrush [Bot] and 118 guests