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
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.
yes u have to make it from sync to async and then need to check if its not bring down take logbackup and shrink after done ur process make it as before
I did the below.. and all restored. but the table still does not have the recoed 104. RESTORE DATABASE DB123 FROM DISK = 'D:\SQL_DATA\PRODUCT\PRODUCT_FULL_1.BAK' WITH NORECOVERY, REPLACE RESTORE DATABASE DB123 FROM DISK = 'D:\SQL_DATA\PRODUCT\PRODUCT_DIFF_1.BAK' WITH NORECOVERY RESTORE LOG DB123 FROM DISK = 'D:\SQL_DATA\PRODUCT\PRODUCT_LOG_2.TRN' WITH RECOVERY, STOPAT = '2022-07-04 17:37:59'
It executed successfully. Please refer below MS docs docs.microsoft.com/en-us/sql/relational-databases/backup-restore/restore-a-sql-server-database-to-a-point-in-time-full-recovery-model?view=sql-server-ver16
Superb explanation and well done , thank you 🙂
Thank you so much.. Very clear n helpful session!
Thank you! Question: In T-SQL you can restore down to the seconds, but in the GUI only down to the minutes?
Thanks man, you saved my day :)
Very well explained ...👍👍👍👍
Fantastic. Thank you so much. 🙏
So can I restore today's data to the previous 3 days just using full data recovery?
Hi do database is in recovery pending. And if backups are not available we can do in that case.
You will have LSN mismatch
@@righttolearnbk database goes into recovery pending and backups are not available to restore a database then how we can bring database to online
@@sqlserver6395if Database is in restoring state then use below query to bring it online
restore Database [database_name] with recovery
Excellent session. Waiting for your next video :)
Super bro.. Good explanation.
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
RESTORE DATABASE YourDatabase FROM DISK = 'Path\To\Your\FullBackup.bak' WITH STANDBY = 'Path\To\Your\UndoFile.undf';
Nice explanation
Hi , I love your videos . I would really appreciate if u can plz make videos on SQL performance tunning and solving high cpu usages.
Ok. I will start as early as possible
@@righttolearnbk thank you so much and looking forward to it 🙂
@@righttolearnbk hi bro .. always on features with full detailed video ..pls pls help
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.
you can use third party tools for that.
Do one video on log file full on Ag database and how we can trouble shoot and bring log file to normal state
yes u have to make it from sync to async and then need to check if its not bring down take logbackup and shrink after done ur process make it as before
Any script to restore database on schedule automatically
Take tail log backup with no_truncate option.restore log 2 stopat with no recovery and finally restore tail log backup with recovery.
Next two rows add we get to by using tail log BACKUP
Nice one
6:08 pm onwards we can take the backup
Upto 6.04.59 we restore with norecovery
Then again we restore that latest backup file with recovery
You will have LSN mismatch
I did the below.. and all restored. but the table still does not have the recoed 104.
RESTORE DATABASE DB123
FROM DISK = 'D:\SQL_DATA\PRODUCT\PRODUCT_FULL_1.BAK' WITH NORECOVERY, REPLACE
RESTORE DATABASE DB123
FROM DISK = 'D:\SQL_DATA\PRODUCT\PRODUCT_DIFF_1.BAK' WITH NORECOVERY
RESTORE LOG DB123
FROM DISK = 'D:\SQL_DATA\PRODUCT\PRODUCT_LOG_2.TRN' WITH RECOVERY, STOPAT = '2022-07-04 17:37:59'
The delete timestamp might be incorrect. Please watch this video for more clarity
th-cam.com/video/NEQW1RUgpJ8/w-d-xo.html
Please make a video on LSN
👍
nice
STOPAT SCRIPT IS WRONG PLEASE EXECUTE AND EXPLAIN
It executed successfully. Please refer below MS docs
docs.microsoft.com/en-us/sql/relational-databases/backup-restore/restore-a-sql-server-database-to-a-point-in-time-full-recovery-model?view=sql-server-ver16