Backup command

Edit online

Use the backup command to back up all or part of one or more SQL databases from the SQL Server to IBM Storage Protect Snapshot.

You can enter the asterisk (*) wildcard character to back up all databases. You can specify more than one database for multiple database and transaction log backups.

When you use the backup command, remember the following facts:
  • You cannot back up or restore the tempdb database because this database is created by the SQL Server each time the server is started.
  • The user ID that is used by IBM Storage Protect Snapshot to log on to the SQL Server must have the SQL Server SYSADMIN fixed server role.
  • You can use the TRANSACT-SQL database consistency checker statement DBCC CHECKDB ('DBNAME') to verify the integrity of the SQL databases before you back them up.
  • Backup syntax Use the backup command syntax diagrams as a reference to view available options and truncation requirements.

  • Backup positional parameters

    Positional parameters immediately follow the backup command and precede the optional parameters.

  • Backup optional parameters

    Optional parameters follow the backup command and positional parameters.

  • Backup examples

    The following examples are provided to show how the backup command can be entered with various parameters and options.