Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Concurrent Administrative Operations

Concurrent Administrative Operations

SQL Server 2000

This table illustrates the administrative tasks that are or are not allowed to run at the same time.

Note  File shrink operations spend most processing time reallocating pages into areas retained after the shrink has completed, and then attempt to change the file size only as the last step. File shrink operations can be started while a backup is running, provided the backup finishes before the file shrink attempts to change the size of the files.

© 2015 Microsoft