In msdb.dbo.RestoreHistory, the Restore_Type can be NULL.

See https://learn.microsoft.com/en-us/sql/relational-databases/system-tables/restorehistory-transact-sql?view=sql-server-ver15

restore_type / char(1) / Type of restore operation

  • D = Database
  • F = File
  • G = Filegroup
  • I = Differential
  • L = Log
  • V = Verifyonly
  • Can be NULL.

I understand what D to V stand for.

However what kind of DB restore history record would have restore type NULL?


1 Answer 1


The column is NULLable on the table, so technically that column can be NULL because no constraint enforces otherwise--that's what the docs are defining.

However, there is no scenario where you would expect SQL Server to intentionally save a NULL restore type.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.