Back up and restore replicated databases

It is important to establish a backup policy that covers all the elements of a replicated iBase database.

The following artifacts must be completed at all sites:

  • The iBase security connection file (ids file)

  • The iBase database connection file (idb file)

  • The iBase database and application folders - the locations of database templates, Analyst's Notebook templates, icons

Then, depending on the type of site, the backup can also include the:

  • Distribution database

  • Publication databases

  • Subscription databases

  • SQL Server system databases (the primary, msdb, and model databases)

  • SQL Server replication scripts

For information about backing up SQL Server databases, see the Microsoft™ SQL Server documentation.