Briefly explain the different SQL Server recovery models
What will be an ideal response?
SQL Server supports three recovery models: simple, full, and bulk logged. The simple recovery model does not create logs of any changes to the database. This recovery method relies only on complete database backups in the event that the database must be recovered. The full recovery model logs all changes that are made to the database. The bulk-logged recovery model logs all changes to the database except for changes that would result in large log entries.
You might also like to view...
You want your customer service staff to do a better job of handling customer complaints.
What will be an ideal response?
List the types of opinions that may be issued by an auditor on a company's financial statements and explain the circumstances under which is issued
What will be an ideal response?