Microsoft SQL Server and/or SQL Agent Start
|
-
Start SQL Server and SQL Server Agent services
(You will select this option when both, SQL Server and SQL Server Agent, are stopped or when SQL Server is running but the SQL Server Agent is stopped)
-
Start SQL Server service
(You will select this option when both, SQL Server and SQL Server Agent, are stopped and if you want to start only the SQL Sever)
|
Microsoft SQL Server and/or SQL Agent Stop
|
-
Stop SQL Server and SQL Server Agent services.
You will select this option:
- When both SQL Server and SQL Server Agent are running.
- When SQL Server is paused but the SQL Server Agent is running.
- When SQL Server is running/paused but the SQL Server Agent is stopped.
-
Stop SQL Server Agent service.
(You will select this option when you want to stop a running SQL Server Agent)
|
Microsoft SQL Server Pause or Resume
|
-
Pause SQL Server service
(You will select this option when you want to pause a running SQL Server)
-
Resume SQL Server service
(You will select this option when you want to resume a paused SQL Server)
|
Microsoft SQL Server Kill Session
|
|
Microsoft SQL Server Backup Database
|
-
Creates a backup of the database specified by Database Name in the Parameters section of the job.
-
Unless specified by editing the monitoring configuration of a deployed target in the Backup Path value, the database backup files will be saved to the default SQL Server backup location. The path specified must not end in a backslash.
-
The Backup job is also available as a button on the Database page in the Backup Management section as Backup Now.
(You will select this job when you want to take a backup of the specified database.)
-
The Backup job comes with Full, Differential, or Transaction Log options.
-
If running a Transaction Log backup job, all of the databases in the job need to utilize Microsoft SQL Server Full Recovery Model.
-
The Backup job also comes with the option to backup all databases on an instance. This option is available when creating the backup job from the Job Activity page (Figure 6-1).
-
This option will back up all databases except master , model , msdb , and tempdb .
|
Microsoft SQL Server Delete Backup Database
|
-
Removes the backup file from the SQL Server by specifying Media Set ID and full path to the backup file in the Job Parameters section.
-
The Delete Backup job is also available as a button on the Database page in the Backup Management section as Delete.
(You will select this job when you want to remove backup file that is no longer needed)
|
Microsoft SQL Server Restore Database
|
-
Restores a database from backup by specifying the full path to the backup file as well as the database name in the Job Parameters section.
-
The Restore Database jobs is also available as a button on the Database page in the Backup Management section as Restore.
(You will select this option when you want to restore a database from a backup taken using the Microsoft SQL Server Backup Database job.)
-
The restore job may be run with a full backup file or a full backup file plus a differential backup file.
|
Microsoft SQL Server Restore Database (Full Model)
|
-
Restores a database from backups utilizing the Full Recovery Model by specifying the database name as well as the date and time desired to be restored to.
-
The Restore Database (Full Model) job is also able to be executed from the Database page in the Backup Management section.
|
Microsoft SQL Server Cluster Failover
|
-
Allows for a controlled failover to a new node in the Microsoft SQL Server Cluster.
-
Specifying the target node is optional, if not specified, Microsoft SQL Server will choose the best node.
|