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
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.
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
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'
Superb explanation and well done , thank you 🙂
Thank you so much.. Very clear n helpful session!
Very well explained ...👍👍👍👍
Excellent session. Waiting for your next video :)
Fantastic. Thank you so much. 🙏
Super bro.. Good explanation.
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 :)
Nice explanation
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
So can I restore today's data to the previous 3 days just using full data recovery?
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
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
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
Next two rows add we get to by using tail log BACKUP
Nice one
Take tail log backup with no_truncate option.restore log 2 stopat with no recovery and finally restore tail log backup with recovery.
Any script to restore database on schedule automatically
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.
6:08 pm onwards we can take the backup
Please make a video on LSN
👍
nice
Upto 6.04.59 we restore with norecovery
Then again we restore that latest backup file with recovery
You will have LSN mismatch
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
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
ua-cam.com/video/NEQW1RUgpJ8/v-deo.html