Comprehensive data protection for all workloads
Post Reply
01alan
Lurker
Posts: 2
Liked: never
Joined: Jul 17, 2018 12:12 pm
Full Name: ALan Shepherd

Clearing / Reducing SQL Express B&R 9.0

Post by 01alan » Jul 17, 2018 1:25 pm

We are using Backup & Replication 9.0
We have reached the 10GB limit of SQL Express, one table Backup.Model.BackupTaskSessionsProgress is at 6GB, some of the entries go back to 2016

What are the safe options for reducing the size of this table/database?

Would we risk losing the ability to restore?

Any suggestions would be much appreciated

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

Re: Clearing / Reducing SQL Express B&R 9.0

Post by foggy » Jul 17, 2018 1:32 pm

Hi Alan, what session history retention settings do you have? It would make sense to specify some shorter period.

01alan
Lurker
Posts: 2
Liked: never
Joined: Jul 17, 2018 12:12 pm
Full Name: ALan Shepherd

Re: Clearing / Reducing SQL Express B&R 9.0

Post by 01alan » Jul 17, 2018 2:58 pm

Hi Foggy

We have 100 sessions and 12 weeks, given that it is used daily I am at a loss to understand why we have records (84m) dating back to the installation mid 2016.

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

Re: Clearing / Reducing SQL Express B&R 9.0

Post by foggy » Jul 17, 2018 3:08 pm

Looks like retention didn't work properly somewhere in the past. I recommend contacting support for a closer look and assistance on cleaning up the database.

Post Reply

Who is online

Users browsing this forum: Google [Bot] and 35 guests