Other Times to Back Up a Database

In addition to routine dumps, dump a database each time you upgrade a user database, create a new index, perform an unlogged operation, or run the dump transaction with no_log or dump transaction with truncate_only command.

Related tasks
Upgrading a User Database