Database Reference
In-Depth Information
Figure 11.106
Running the maintenance plan.
When the maintenance task is finished running (in our environment, it took
approximately 10 minutes), click
Close
. You should see a success message like the one
shown in
Figure 11.107
when the task is done.
Figure 11.107
Task completion.
Now that we have optimized the DS2 database, we need to perform a database backup.
There will be two database backup operations that need to occur. The first is a full
backup and the second is a backup of the transaction logs. To begin, in the Microsoft
SQL Server Management Studio, expand
Databases
and right-click
DS2, Tasks, Back
Up...
. On the
Back Up Database - DS2
page, click
OK
. Once the backup operation
completes, click
OK
.
Figure 11.108
provides a screenshot of what this looks like.