Jump to content

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
7 минут назад, batbold сказал:

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


Please wait for the answer in the incident. 


Share this post

Link to post

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Create New...

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.