SQL Server DBA Tutorial 80-How to Restore a Database to Specific Time Point in Time in SQL Server

In this video you will learn how to restore SQL Server database to Point in time using Full, Differential and T-Log backups using SQL Server management studio as well as T-SQL Script. It goes through a scenario to recover database to a specific time, step by step restoring SQL Server database to point in time.

Blog post link for this video:

Visit our website to check out SQL Server DBA Tutorial Step by Step

[agusnaza]

The whole DBA Tutorial playlist is just gold, thanks

[wilfriedessonkong]

GREAAAT VIDEO, very good and simple explanations. Thank you so much

[stefanminehan]

Very helpful for us rookies. Cheers! :)

[amg]

You mentioned that the restore can be done in one step instead of two steps. Can you elaborate the one step only to restore the database?.

[DreOmar]

4:10 it only allows me to add full backup and not the differential ones...

[ankursinha]

Hi, i am just curious to know that here you didn't give a specific time until where the data needs to be restored so exactly how is this a PIT recovery. Please correct me if i missed something.

[buugedy]

I am trying to restore prod db from prod server to test server over test db. Have copied full and diff backups to test server. Problem - when I want to do diff restore, I cannot do it, because cannot add at the same time full and diff files into window. Only one file is visible, either full or diff, but not both together. Please assist, what is wrong? Why diff backup does not match with full backup? I have only full and diff backup files no any transaction files.

[noorhirjee]

there is no demo of 6.09 pm trans log backup . Can you explain clearly about tail backup and restore .Thanks

[kcsvenkat]

Hi,

It is very nice session. I have one question.
what NOUNLOAD opposition in the recovery, what is the use it

Thanks
Chandra

[lakshayarora]

Hi, it was a great video. However, wanted to know one thing that our db model should be in full recovery mode? Or in simple mode will do?

[dragonballsupere]

It is not PTR Bro, it is recovery, WHERE U USED PTR

[JohnRockBilodeau]

Thanks for the tutorial. One question though about point in time recovery. Let's say your database is in full recovery mode and you have a full backup that done at midnight every day and something goes wrong at 8:00AM. Is there a way to restore the last full backup and then roll forward the changes from the transaction log file (Not transaction log backup) to say 7:59AM?

If so how would you do that?

[TouchMe-Tech]

can i get the deleted database from sql server 2005?
please help,
if you have any suggestion to solve this problem

[adityac]

This is not accurate. You should've used STOPAT parameter for an appropriate explanation of the point in time.