Skip to content

Commit 7341e86

Browse files
urosmilCopilot
andauthored
Revise caution note for tempdb file layout changes
Updated caution note regarding tempdb file layout changes to clarify the rollback process and potential inconsistencies across replicas. Co-authored-by: Copilot Autofix powered by AI <175728472+Copilot@users.noreply.github.com>
1 parent 4c0458f commit 7341e86

1 file changed

Lines changed: 1 addition & 1 deletion

File tree

‎azure-sql/managed-instance/tempdb-configure.md‎

Lines changed: 1 addition & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -87,7 +87,7 @@ ALTER DATABASE tempdb ADD FILE (NAME = 'file_name')
8787
```
8888

8989
> [!CAUTION]
90-
> Changes to the `tempdb` file layout apply to each replica and save in the service configuration. Adjust the file layout during lower traffic hours. Apply changes one file at a time, and wait for the operation to report success before starting another file operation. A new file can become active on a replica before the operation finishes on every replica. If the operation fails, the service attempts to roll back the configuration change by removing the file. The rollback might not be possible after workload starts using the file, which can leave the file layout inconsistent across replicas until the affected replica restarts and restores the saved configuration.
90+
> Changes to the `tempdb` file layout are applied to each replica and saved in the service configuration. Adjust the file layout during lower traffic hours. Apply changes one file at a time, and wait for the operation to report success before starting another file operation. A new file can become active on a replica before the operation finishes on every replica. If the operation fails, the service attempts to roll back the configuration change by removing the file. The rollback might not be possible after workload starts using the file, which can leave the file layout inconsistent across replicas until the affected replica restarts and restores the saved configuration.
9191
9292
To remove an existing `tempdb` file, use the following command:
9393

0 commit comments

Comments
 (0)