Shrinks the size of the data and log files on the specified database.
By shrinking the size of data files and log files on a database, you can recover space by moving pages of data at the end of the file to unoccupied space near the front of the file. De-allocated pages at the end of the file are returned to the file system.
The request body accepts optional truncateLogsOnly
body parameter. If true
, only the logs are truncated. By default, false
.
A timeout value (in hours) can optonally be set for the shrink job. If unspecified, the job times out after two hours.
Role-based Permissions
To perform this operation, a principal must belong to a group that has been assigned the appropriate role-based permissions. The table identifies the roles with permission to perform this operation.
Consumer Contributor Data Bridge Admin NO NO YES To learn more about role-based permissions in Data Bridge, see Access Controls.