- run dbcc checkdb and dbcc checkalloc
- put database in single-user mode
- execute sp_flushstats
- ... wait some time (approx. 1 min)
- execute checkpoint
- dump database
- load databases on target db
- execute sp_post_xpload - it ensures, that all indexes are correct
- execute sp_indsuspect - findout corrupted indexes