Sample Header Ad - 728x90

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