Tag Archives: SQL Server Interview Questions & Answers

SQL Server Interview Questions & Answers 2

SQL Server Interview Questions & Answers 2 Question 6: How is a point in time recovery performed independent of a server down situation? Ans. It depends on which backup types are issued.  In this example let’s assume that full, differential and transaction log backups are issued. 1. Restore the most recent full backup with the NORECOVERY

SQL Server Interview Questions & Answers

SQL Server Interview Questions & Answers Question 1: How does the database recovery model impact database backups? Ans. Database recovery model is responsible for the retention of the transaction log entries.So the setting determines if transaction log backups need to be issued on a regular or not. SQL Server database recovery models: Simple – Committed transactions