A full
backup should be completed as soon as
possible!
Prior
incremental or differential backups are
no longer useful because they reference
database pages that were reordered by
the defragmentation process. ESEUTIL
defragments a database by creating a new
database, copying the old database
records to the new one, and discarding
unused database pages, which results in
a newly organized compact database file.
Microsoft
recommends a conservative 5 - 7 GB per
hour for a defrag operation, which means
that your server will be offline for as
long as it takes, assuming no hardware
failures will occur.
When you run
ESEUTIL
/d against a
database to defragment it, the streaming
file associated with the database is
automatically defragmented. This is the
default behavior.
For example, if you run
the following command at a command
prompt:
The Priv1.edb and
Priv1.stm files are defragmented. If you
do not want the streaming file to be
defragmented, include the /i option.
Run
ESEUTIL with the /p switch to configure
ESEUTIL to create the new defragmented
database on an alternate location (for
example, to a location on a different
hard disk). This switch lets you
preserve your original defragmented
database (which lets you revert back to
your original database if necessary).
This switch also significantly reduces
the amount of time it takes to
defragment a database, because you are
rebuilding to a new location, rather
then rebuilding the database in place.
|