Back to Blog
Edit backup plan cloudberry server7/8/2023 No maintenance tasks are run against the SQL Server system databases. Generate a maintenance plan that runs maintenance tasks against all user-created databases. No maintenance tasks are run against user-created databases.Īll user databases (excluding master, model, msdb, tempdb) Generate a maintenance plan that runs maintenance tasks against each of the SQL Server system databases. Generate a maintenance plan that runs maintenance tasks against all SQL Server databases.Īll system databases (master, msdb, model) When selected, the drop down list provides the following options: All databases, All system databases, All user databases, These specific databases. Specify the databases affected by this task. The New Connection dialog box is described below. Select the server connection to use when performing this task.Ĭreate a new server connection to use when performing this task. This task allows you to perform full, differential, files and filegroups, and transaction log backups. Backing up the database is important in case of system or hardware failure (or user errors) that cause the database to be damaged in some way, thus requiring a backed-up copy to be restored. Use the Back Up Database Task dialog to add a backup task to the maintenance plan. Applies to: SQL Server (all supported versions)
0 Comments
Read More
Leave a Reply. |