on 06-18-2009 8:35 PM
Hello all,
I have the trabsaction logs back say before 10th,then I take a fullonline backup on 11th and then I have transaction logs backup till 20th,now I take a full online backup on 21st
Now my question is if I want to restore my system and I use the online backup of 11th and then apply transactional logs till 20th,will I be able to restore my system
Rohit
Hi Rohit ,
Note that Transaction logs are used for Point in time recovery .
The recovery process is as follows as per the Microsoft:
To apply a transaction log backup, the following requirements must be met:
1 .The immediately previous full database backup or differential database backup must be restored first.
2 .All transaction logs that are created after that full or differential database backup must be restored in chronological order. If a transaction log backup in this log chain is lost or damaged, you can restore only transaction logs before the missing transaction log.
3. The database has not yet been recovered. The database cannot be recovered until after the final transaction log has been applied. If you recover the database after restoring one of the intermediate transaction log backups, that before the end of the log chain, you cannot restore the database past that point without restarting the complete restore sequence, starting with the full database backup.
Hope your doubt is clear now.
Regards,
Nibu
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Rohit,
Can I restore 10th backup and then apply the transaction logs till 20th to restore the system and not use 17th backup
I think yes you can, if you have all transaction logs from 10th to 20th but again it will take more time. if you use 17th Backup & transaction logs from 17th to 20th will be less time consuming that 1st one.
Thanks
Sushil
Dear Rohit,
Yes you can .
But you should have all the transaction logs and it should be restored in a chronological order .
Please refer the link http://msdn.microsoft.com/en-us/library/ms189596.aspx describing the same
situation and different solutions.
Regards,
Nibu
Rohit,
I think Yes you can restore your system but you should have all transactional logs till 20th.Also this might take more time ( 9 days transaction logs)
If you have 21st backup then it will need less time than 1st to restore 21st backup rather than applying 9 days transactions logs.
Hope it helps
Thanks
Sushil
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
I would not keep so much gaps in backup because so many transactions logs needs to be applied in sequence. how about taking weekly full backup to reduce number of transaction logs at any given time?
Also check out following link
[http://help.sap.com/saphelp_nwce10/helpdata/en/f2/31ad41810c11d288ec0000e8200722/content.htm]
User | Count |
---|---|
88 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.