Different Backup mode in SQL Server.

Updated: 10 hours ago


Different Backup mode in SQL Server. As a DBA you must know how point of time recovery performed?

Answer : Point In-Time recovery means we need to recover data till the specific given time, it depends on which back up types are issued.

We have a database and we are performing full, differential, and transaction log backups.

Due to data corruption we need to recover/restore our database till 3:17 AM.

We have the latest transaction log file available at 3:30 AM.

1. Restore the most recent full backup with the NORECOVERY clause. 2. Restore the most recent differential backup with the NORECOVERY clause. 3. Restore all of the subsequent transaction log backups with the NORECOVERY clause expect the last transaction log backup. 4. Restore the last transaction log backup (3:30 AM) with the RECOVERY clause and a STOPAT (3:17 AM) statement.

For Demo you can look below link.


Don't forget to subscribe the channel.

1 view

Recent Posts

See All

ADDRESS :

LOCATION :

701, Linden, Rosalie Complex Khadakpada, Kalyan (W) Mumbai, Maharashtra 421301)

CONTACT US :

+919322846017  &   +919867493019

EMAIL: 

QUICK LINKS :

SUBSCRIBE HERE :

Don’t Miss a Lecture. Subscribe Today. 

telegram-512.png

© 2019 DBA Trainings. Proudly Managed By Pearl Organisation

  • Grey LinkedIn Icon
  • Grey YouTube Icon
  • Grey Twitter Icon
  • Grey Facebook Icon