Tag Archives: SQL Server Interview Questions & Answers 2

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