Backup command

Use the backup command to back up all or part of one or more SQL Server databases from the SQL Server to Tivoli® Storage Manager storage on the Tivoli Storage Manager 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.