Concurrent Administrative Operations

Administering SQL Server

Administering SQL Server

Concurrent Administrative Operations

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.