types of sql database backup Fundamentals Explained

This recovery model is created to be utilised when you don't perform backup from the transaction log from the database. In uncomplicated Restoration, It's not at all your obligation to “empty the log” (or “truncate the log”), as SQL Server will do this for yourself.To see all objects that aren't dynamic management views, use NOT LIKE 'dm%'.

read more