Jump to content
bunger

Script to clean up db tables

Recommended Posts

Running KSC v10 against SQL Server Express.  The KAV database is at 10GB and is preventing logins or the security center from running.  The Application Event Log is full of these:

 

Could not allocate space for object 'dbo.TransEventsDetails'.'PK__TransEve__DF98CDDD123EB7A3' in database 'KAV' because the 'PRIMARY' filegroup is full. Create disk space by deleting unneeded files, dropping objects in the filegroup, adding additional files to the filegroup, or setting autogrowth on for existing files in the filegroup.

 

Is there a sql script that I can run to delete extraneous table data to help reduce the db size?

Share this post


Link to post

I have similar issue  - can anyone share the script with me ??  i have registred incident : INC000009871608

Share this post


Link to post
7 минут назад, batbold сказал:

I have similar issue  - can anyone share the script with me ??  i have registred incident : INC000009871608

Hello!

Please wait for the answer in the incident. 

Thanks!

Share this post


Link to post

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×

Important Information

We use cookies to make your experience of our websites better. By using and further navigating this website you accept this. Detailed information about the use of cookies on this website is available by clicking on more information.