Skip to content

Commit 9b04571

Browse files
authored
Merge pull request #16172 from MladjoA/patch-3
Patch 3
2 parents 44c6f9a + d04dbb4 commit 9b04571

1 file changed

Lines changed: 4 additions & 2 deletions

File tree

docs/database-engine/configure-windows/suppress-recovery-model-errors-server-configuration-option.md

Lines changed: 4 additions & 2 deletions
Original file line numberDiff line numberDiff line change
@@ -23,21 +23,23 @@ Use the **suppress recovery model errors** advanced configuration option to spec
2323

2424
## Examples
2525

26-
The following example enables suppression of error messages related to the change of database recovery model, and then executes command for changing database recovery model, returning warning only. Recovery model is not actually changed. Make sure to replace *Database* with the actual database name.
26+
The following example enables suppression of error messages related to the change of database recovery model, and then executes command for changing database recovery model, returning warning only. Recovery model is not actually changed. Make sure to replace *my_database* with the actual database name.
2727

2828
```sql
2929
-- Turn advanced configuration options on:
3030
sp_configure 'show advanced options', 1 ;
3131
GO
3232
RECONFIGURE ;
3333
GO
34+
3435
-- Enable suppression of error messages for recovery model change:
3536
sp_configure 'suppress recovery model errors', 1 ;
3637
GO
3738
RECONFIGURE ;
3839
GO
40+
3941
-- Execute command for changing recovery model to Simple:
40-
ALTER DATABASE MyDatabase SET RECOVERY SIMPLE;
42+
ALTER DATABASE my_database SET RECOVERY SIMPLE;
4143
GO
4244
```
4345

0 commit comments

Comments
 (0)