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.
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];
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.