Export (0) Print
Expand All
Expand Minimize

How to shrink a database (Enterprise Manager)

SQL Server 2000

How to shrink a database (Enterprise Manager)

To shrink a database

  1. Expand a server group, and then expand a server.

  2. Expand Databases, right-click the database to shrink, point to All Tasks, and then click Shrink Database.

  3. To specify how much to shrink the database, select from these options:
    • For Maximum free space in files after shrinking, enter the amount of free space you want left in the database after shrinking. Use the Database Size, Space free value as a guideline.

    • Select Move pages to beginning of file before shrinking to cause the freed file space to be retained in the database files, and pages containing data to be moved to the beginning of the database files.
  4. Click Schedule to create or change the frequency or time when the database is automatically shrunk.

  5. Click Shrink files if you want to shrink individual database files.

Note  You cannot shrink a database smaller than the size of the model database.

See Also

Shrinking a Database

© 2014 Microsoft