Recovery_model for backupset table null sqlserver
0
votes
1
answer
136
views
Going through https://www.sqlshack.com/understanding-database-recovery-models/
I see that there are three types of recovery models:
- SIMPLE
- FULL
- BULK_Logged
But for the table msdb.dbo.backupset I can see the recovery_model column can be null. In what case would this take a NULL value. How to create a backup such that it falls into this case.
Asked by Sonali Gupta
(99 rep)
Apr 29, 2021, 06:21 AM
Last activity: Apr 29, 2021, 09:24 AM
Last activity: Apr 29, 2021, 09:24 AM