Exporting closed tickets to a separate database.
Good morning all,
I wonder if you can assist?
Our database is currently running high and we wish to keep it below the 10 gig threshold SQLExpress has. I have tried the following all with minimal to no success:
shrinking the database data
delete from aaaaccsession
delete from auditrecord
delete from recentitems
delete from errorlog
archiving all closed tickets older than 2 years.
Can you please advise on what else can be done to reduce the size of the database?
Is there a way to move all closed tickets older than 2 years to another database using SQL, which would then be accessible if required?
Any advice or assistance would be most welcome.
New to ADSelfService Plus?