There are three type of recovery models are there. They are – Full Recovery Model : In full recovery model…
Why normally full recovery model is used in production server?
Because, in full recovery model every transaction store into transaction log until either a transaction log backup occurs or the…
How differential backup and log backup depends on full back up?
As because log backup’s ‘Database Backup LSN’ number is equals to Full backup’s ‘Checkpoint LSN’ number and log backup’s ‘Checkpoint…
What is the query and table by which we can get the Backup LSN number?
USE [master] RESTORE HEADERONLY FROM DISK = N’C:\Temp\Full1.BAK’ RESTORE HEADERONLY FROM DISK = N’C:\Temp\Tran1.TRN’ RESTORE HEADERONLY FROM DISK = N’C:\Temp\Tran2.TRN’…