Mike Skutta Blog

Sitecore How-To: Clean Up After Restoring a Sitecore Database

Eric Carron and Mike Skutta


This is an article in a series of Sitecore how-to articles. These articles are meant to be quick guides to accomplish various tasks within Sitecore. The how-to articles have proven to be very helpful internally at One North Interactive https://www.onenorth.com. These articles assume working Sitecore knowledge. I just wanted to share the articles with the community. Hopefully you find them helpful.


After you import/restore a Sitecore database, you will want to clean up some SQL tables.

Your Lucene indexing may not work correctly until this step is completed.

Step-by-step guide

  1. Execute the following SQL statement on each of the Sitecore databases (Core, Master, Web):

     TRUNCATE TABLE [dbo].[EventQueue];
     TRUNCATE TABLE [dbo].[PublishQueue];
     TRUNCATE TABLE [dbo].[Properties];
  2. Execute the following SQL statement on the Web database. It is helpful to have history in the Master database.

     TRUNCATE TABLE [dbo].[History];

NOTE: Some modules may add data to the properties table. Removing this data may have repercussions on those modules.

Similar Posts