Before you run dump database for a cross-platform dump and load, use the following procedures to move the database to a transactional quiescent status:
Verify the database runs cleanly by executing dbcc checkdb and dbcc checkalloc.
To prevent concurrent updates from open transactions by other processes during dump database, use sp_dboption to place the database in a single-user mode.
Flush statistics to systabstats using sp_flushstats.
Wait for 10 to 30 seconds, depending on the database size and activity.
Run checkpoint against the database to flush updated pages.
Run dump database:
Place the database in a single user mode by sp_dboption.
Run sp_flashstats in the database.
Run checkpoint in the database.
Run dump database.
