Is there a programmatic way to validate that that restored database from an Azure SQL PITR backup is valid?
What have I tried
I know the domain entities that are stored in the database and can verify if certain tables have entries from a specific period. However this seems to be too dependent on the type of data we are storing
Is there a system based way to do this comparing audit / transaction logs. I am not a database administrator and might not have the correct terms to explains the problem.
Question
How do I validate that the database X I restored from a database backup went smoothly. Is there a checklist that I can check to ensure this that does not rely on the actual table definition (timestamps columns)?