"MS SQL" To view task execution progress

When backing up or restoring a database, I typically use the MS SQL Tools Wizard, because the tool wizard does not show the status of the task execution process.

If the database is relatively large execution time, the task when the execution is confused, such as the following steps to "Backup" database as an example:

1. Select the database you want to back up, and right-click on "task-to-backup":

2, set the backup options, click the "OK" button:

3, the database backup ....

4, in fact, when the backup option is set up, do not click the "Confirm" button, click on the " script " option above:

5, the system automatically open a "query" interface, and the database backup as a script, click the "Execute" button to perform a script backup:

6. The Messages tab displays the progress of the task execution:

This feature is not just for database backup and restore, but for options that can be executed with a script to see the progress of the task through the Messages Options page.