Daily we populate a swap table in our production environment and rename it with the original table. During this process, we disable the indexes and load the data and rebuild the indexes on swap table to speed up the process. From last few weeks we are observing page file corruption on this table after rename process and all the queries hitting the main table are failing throwing error-Could not continue scan with NOLOCK due to data movement. Any help would be appreciated.
What were the errors when you ran dbcc checkdb? With no_infomsgs all_errormsgs if you haven't run it yet.
Sue