How to Back Up the Production Service Manager Database

  • Article

Applies To: System Center 2012 R2 Service Manager, System Center 2012 SP1 - Service Manager

Use the following procedure to back up the production Service Manager database in Microsoft SQL Server 2008 R2. Steps might differ for Microsoft SQL Server 2012.

To back up the Service Manager database

  1. After you connect to the appropriate instance of the Microsoft SQL Server Database Engine, in Object Explorer, click the server name to expand the server tree.

  2. Expand Databases, and depending on the database, either select a user database or expand System Databases and select a system database.

  3. Right-click the database, point to Tasks, and then click Back Up. The Back Up Database dialog box appears.

  4. In the Database list, verify the database name. You can optionally select a different database from the list.

  5. You can perform a database backup for any recovery model (FULL, BULK_LOGGED, or SIMPLE).

  6. In the Backup type list, select Full.

    Note

    After you create a full database backup, you can create a differential database backup. For more information, see Create a Differential Database Backup (SQL Server).

  7. Optionally, you can select Copy Only Backup to create a copy-only backup. A copy-only backup is a SQL Server backup that is independent of the sequence of conventional SQL Server backups. For more information, see Copy-Only Backups (SQL Server).

    Note

    When the Differential option is selected, you cannot create a copy-only backup.

  8. For Backup component, click Database.

  9. Either accept the default name that is suggested in the Name box for the backup set, or enter a different name for the backup set.

  10. Optionally, in the Description box, enter a description of the backup set.

  11. Specify when the backup set will expire and when it can be overwritten without explicitly skipping verification of the expiration data.

    Note

    For more information about backup expiration dates, see BACKUP (Transact-SQL).

  12. Choose the type of backup destination by clicking Disk or Tape. To select the paths of up to 64 disk or tape drives that contain a single media set, click Add. The selected paths appear in the Backup to list.

  13. To view or select the advanced options, in the Select a page pane, click Options.

  14. Select an Overwrite Media option by clicking either Back up to the existing media set or Back up to a new media set, and erase all existing backup sets.

  15. In the Reliability section, select either Verify backup when finished or Perform checksum before writing to media, and then optionally select Continue on checksum error. For more information, see Possible Media Errors During Backup and Restore (SQL Server).

-----
For additional resources, see Information and Support for System Center 2012.

Tip: Use this query to find online documentation in the TechNet Library for System Center 2012. For instructions and examples, see Search the System Center 2012 Documentation Library.
-----