Backup command

Use the backup command to back up all or part of one or more SQL Server databases from the SQL Server to IBM Spectrum Protect storage on the IBM Spectrum Protect server.

You can enter the * character to backup all databases. You can specify more than one database for multiple database and transaction log backups.

When you use the backup command, consider the following guidelines:
  • Simple recovery model databases are automatically excluded from log backups.
  • The master database is automatically excluded from log and differential backups.
  • You cannot back up or restore the tempdb database because this database is created by the SQL Server each time that the server is started.
  • Although full and differential backups include a part of the transaction log, that part is the only part that is required to make a restore operation consistent. The partial transaction log is not a log backup and does not truncate the log.
  • The user id that is used by Data Protection for SQL Server 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 Server databases before you back up the databases.