Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Restoring Differential backup issue Expand / Collapse
Author
Message
Posted Friday, September 20, 2013 8:21 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, December 24, 2014 8:51 AM
Points: 139, Visits: 501
Hi all,
Took Full backup
created Table1
Took Tran Log backup
Created Table2
Took Diff backup
Created Table 3
Took Tran backup
Now I am creating another database using above.
how can I restore all 3 backups, can somebody write steps Please in details.
Because I can restore fullback up (creating another db) no recovery, could apply 1st tran backup with no recovry but when it comes to apply differential backup, it wont let me do it.
Post #1496912
Posted Monday, September 23, 2013 9:29 AM
SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Monday, December 22, 2014 2:37 PM
Points: 4,064, Visits: 5,374
You can't restore a differential after restoring a log backup. The order of restores must be:

1. Restore full backup
2. Restore differential backup
3. Restore log backup

So, in your case, if you wanted to create a new database with both tables, you'd restore the full backup with no recovery, then the differential backup with no recovery, then the second log backup with recovery.


Greg
Post #1497446
Posted Monday, September 23, 2013 12:57 PM
SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Friday, December 12, 2014 12:03 PM
Points: 4,363, Visits: 9,547
Greg Charles (9/23/2013)
You can't restore a differential after restoring a log backup. The order of restores must be:

1. Restore full backup
2. Restore differential backup
3. Restore log backup

So, in your case, if you wanted to create a new database with both tables, you'd restore the full backup with no recovery, then the differential backup with no recovery, then the second log backup with recovery.


Or - restore the full backup, the first and second log backups. No need for the differential backup in this scenario.

Note: the only reason to use differentials is to reduce the number of files being restored or allow for not performing a full backup every night (e.g. weekly full, daily differentials - frequent log backups).


Jeffrey Williams
Problems are opportunites brilliantly disguised as insurmountable obstacles.

How to post questions to get better answers faster
Managing Transaction Logs
Post #1497505
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse