Point in time restore in SQL Server || How to restore a database to a specific point in time ||MsSQL

Point-in-Time Recovery (PITR) allows a database administrator to restore or recover a set of data from a backup from a particular time.

This is a real-time scenario where we need to recover a particular table or a row in table in the database.

[harikachinni]

Thank you so much.. Very clear n helpful session!

[pdrxiju]

Superb explanation and well done, thank you 🙂

[balajivangaru]

Excellent session. Waiting for your next video :)

[vaibhavsingh]

Just like snowflake, does SQL server not support TimeTravel????
In Snowflake, one do not need to run a query to store a backup, instead we define a retention_time of table, and you can restore any number of days of historical data within retention_time defined.

[smart-vhxs]

Hi bro,
I have one doubt

Weekly Full backup at every Sunday 12pm
Remaining all days differential back up Monday to Saturday
Every 30 minutes log back up
At the Sunday full backup was crashed how can we recovery the point in time recovery please let me i have faced in this interview at yesterday

[AT-tbhf]

Hi, I love your videos . I would really appreciate if u can plz make videos on SQL performance tunning and solving high cpu usages.

[orturizkyjp]

So can I restore today's data to the previous 3 days just using full data recovery?

[sqlserver]

Hi do database is in recovery pending. And if backups are not available we can do in that case.

[alpesh]

Any script to restore database on schedule automatically

[sqlserver]

Do one video on log file full on Ag database and how we can trouble shoot and bring log file to normal state

[faiqaizaz]

Take tail log backup with no_truncate option.restore log 2 stopat with no recovery and finally restore tail log backup with recovery.

[chinnarajatanniru]

Next two rows add we get to by using tail log BACKUP

[jahgaddesnanupathruni]

6:08 pm onwards we can take the backup

[pavank]

Upto 6.04.59 we restore with norecovery
Then again we restore that latest backup file with recovery

[pravinmore]

I did the below.. and all restored. but the table still does not have the recoed 104.

RESTORE DATABASE DB123
FROM DISK = WITH NORECOVERY, REPLACE

RESTORE DATABASE DB123
FROM DISK = WITH NORECOVERY

RESTORE LOG DB123
FROM DISK = WITH RECOVERY, STOPAT = '2022-07-04 17:37:59'

[akshaygujar]

STOPAT SCRIPT IS WRONG PLEASE EXECUTE AND EXPLAIN