After a policy runs, the Policies tree content pane displays information describing the overall status of all of these operations. The Last Operation Status shows an overview of the most recent backup, restore, or log shipping operations that occurred across your enterprise. Use this view to quickly determine whether your servers are in compliance with your corporate policies.
If your operations are successful, SQL Safe displays a list of these operations and their associated messages. If an operation was unsuccessful for any reason, the Last Operation Status also allows you to rerun the operation from this view instead of requiring you to access the appropriate wizard.
You can rerun any previous operation from this grid. To rerun an operation, check the box to the left of the appropriate operation, and then click Run Selected Operations Again . This request executes the backup or restore using the previous settings.
What is the operation summary box?
The operation summary box displays a list of all operations for the selected topic, such as Backups were canceled by user. SQL Safe provides information in the following columns:
Column Header | Definition |
|---|---|
Instance | Displays the instance name. |
Database | Displays the database name. |
Operation | Displays the type of operation performed. |
Start Time | Displays the start date and time of the most recent operation. |
Can I rerun more than one operation?
Yes, you can quickly rerun one or more operations through the Last Operation Status. Check the boxes next to all appropriate operations, and then click Run Selected Operations Again. To select all of the displayed operations, check the box next to the Instance column title.
How can I capture the provided information?
SQL Safe allows you to copy the list summary and the related messages using the copy buttons to the left of the operation summary box and the messages box. You can then paste this information in another application, such as Notepad. Use the upper copy button to capture the status, instance, database, operation, and start time. Use the lower copy button to capture the same information, but also include the message.