Testing the backup

Before doing this task, verify that logging is turned off for IIS.

Database performance can be downgraded while this test is in progress, but the database remains operational during the test.

Open and log in to Microsoft SQL Server Management Studio.
In the tree-view, open the Management | Maintenance Plans nodes.
Right-click on a plan and select Execute. the Execute Maintenance Plan dialog box opens and reports progress.
To check for errors, view the history.