Thank this author by sharing:
By Dale Elizabeth Corey,
More than once, I have heard, “I never knew that feature existed
in Enterprise Manager”, so I thought I would conjure up a Top Ten List for
Enterprise Manager. However, I will not say that there may be other features
that are not as equally important and these are not necessarily in any order.
The nice thing about Enterprise Manager (see Figure 1) is that it can make
some of the daily mundane chores a lot easier.
Enjoy the read and be sure to leave me “pithy” comments. J I welcome suggestions for other good
tips and tidbits.
Enterprise Manager's Top Ten Features:
6. Management/SQL Server Agent/Database Maintenance Plans – Besides
primarily helping you with backing up your databases and transaction logs,
the wizard (see Figure 7) will help you to reorganize the data on the data
and index pages, compress data files, update index statistics, perform internal
consistency checks of data and data pages, and set up log shipping (for synchronizing
databases with standby servers). You can find the wizard after expanding
a server group, then the server. Look under Management and then right-click
Database Maintenance Plans. If you want to just set up an immediate
backup job or to schedule one a backup job, you can expand a server group,
then the server. Look under Management and then right-click Backup.
Some Enterprise Manager Tips:
October 14, 2004
SQL Server Management Studio - validade database button
This article explains how to use a simple batch file and script file to manage multiple databases on...
Export option (right click in the database - tasks - export data...)
enterprise manager not displaying databases and server in a cluster
Microsoft ships SQL Server with several built-in tools that database administrators (DBAs) can use t...