cancel
Showing results for 
Search instead for 
Did you mean: 

restore SQL server backup

Former Member
0 Kudos

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

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

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

Former Member
0 Kudos

say I have two full backups

one of 10th and other for 17th

Can I restore 10th backup and then apply the transaction logs till 20th to restore the system and not use 17th backup

Rohit

Former Member
0 Kudos

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

Former Member
0 Kudos

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

Answers (1)

Answers (1)

Former Member
0 Kudos

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

Former Member
0 Kudos

Hello all

any more ideas on this?

If I have two online backups say one for 10th and another one for 20th

Can I restore the systen using 10th backup and use the transactional logs after that backup till 22nd to restore the whole system

Rohit

former_member204746
Active Contributor
0 Kudos

simple answer:

Yes you can. this will work.

Former Member
0 Kudos

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]