Purge SQL database

Availability for the Always-On Enterprise

Purge SQL database

Veeam Logoby Rod78 » Tue Apr 25, 2017 1:09 pm

What would be the best thing to do when you reach the SQL Express limitation of 10GB. Upgrading to standard is not an option for us right now.
I'm seeing this error and I'm having trouble starting the GUI as it complain with the same error below

Now using SQL Studio Manager shows me the biggest tables in the db

Which tables are ok to purge and how? Or can I just create a new DB and how do I do that correctly? What happens with my backups if I start using a new db?
btw, I have decreased the session history (whatever that is) in Enterprise Manager, from default 53 weeks to 40. I then performed a Shrink using SQL Studio Manager and the db actually went down from 10GB to 9,5GB. That helped so I now at least can start the GUI
Posts: 10
Liked: never
Joined: Thu Aug 28, 2014 6:42 pm

Re: Purge SQL database

Veeam Logoby foggy » Tue Apr 25, 2017 4:52 pm

Please contact support for assistance with database cleanup.
Veeam Software
Posts: 15860
Liked: 1196 times
Joined: Mon Jul 11, 2011 10:22 am
Full Name: Alexander Fogelson

Return to Veeam Backup & Replication

Who is online

Users browsing this forum: Google Feedfetcher and 1 guest