Purge SQL database

Availability for the Always-On Enterprise

Purge SQL database

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

Hi,
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
Image

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

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
Rod78
Influencer
 
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.
foggy
Veeam Software
 
Posts: 14742
Liked: 1080 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 [Bot], Yahoo [Bot] and 27 guests