Dumping a Database

Before you run dump database for a cross-platform dump and load, move the database to a transactional quiescent status.

  1. Execute dbcc checkdb and dbcc checkalloc to verify the database runs cleanly.
  2. Use sp_dboption to place the database in a single-user mode.
  3. Use sp_flushstats to flush statistics to systabstats.
  4. Wait for 10 to 30 seconds, depending on the database size and activity.
  5. Run checkpoint against the database to flush updated pages.
  6. Run dump database.