Advanced Tools Operations

70.3.4.6 Automatic database backup

Alternatively to the manual backup, SQL Server Enterprise Manager also allows defining a maintenance plan to automatically create a database backup with a user-defined frequency (e.g. once a week).
Microsoft SQL Server Management Studio

It is worth mentioning that in case the SQL Maintenance Plan is configured to "create a sub-directory for each database" (see figure above) to backup Etere databases in separated folders (i.e. one for the production database, another for the doma database and another for the historical database) it will be required to enable the "search also in sub-directories" in the Database Backup parameters section:
Database Backup

NB: Detailed information on how to implement a maintenance plan on a SQL Server can be found in the SQL Server Maintenance Plan chapter.


Microsoft_SQL_Server_Management_Studio
Database_Backup