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.

Show:
Inherited
Protected

Was this page helpful?

Your feedback about this content is important.Let us know what you think.