Database Administration for Specific Platforms › SQL Server/Windows Routine Procedures › Backing Up Your Database › Weekly Database Backups and Update Statistics Are Typical

Weekly Database Backups and Update Statistics Are Typical

Database backups should occur often enough for your particular work environment. Typical schedules include weekly database backup and update statistics. This may not be sufficient for your environment. Assign a database administrator (DBA) for your work area to schedule database backups.

1. Back up the Encyclopedia database <DBCSE> using the database dump device and the following Management Studio command:

   dump database DBCSE to DBCSE_DB_DUMP
   

2. Back up the Coordination Server database <DBDIR> using the database dump device and the following Management Studio command:

   dump database DBDIR to DBDIR_DB_DUMP