How to restore a database from SmartDiff backup files by Wizard or script
WORKAROUND:
In the Restore Wizard, on Select Backup File the last differential file will be automatically chosen (if not the point that you wish to restore to, simply remove that file and click add to select another Differential file). On the Content screen, the Full and Differential will be automatically selected if Intellirestore is checked on.
Full backup files are named: Databasename.smartdiff.f1.bkp, Databasename.smartdiff.f2.bkp, Databasename.smartdiff.f3.bkp
Diff backup files are named: Databasename.smartdiff.f1.d0.bkp, Databasename.smartdiff.f1.d1.bkp, Databasename.smartdiff.f1.d2.bkp
After a Full is run, the subsequent differentials would be named: Databasename.smartdiff.f2.d0.bkp
If the series of backup files were:
D:\Backup\2005\Congaree.smartdiff.f1.bkp
D:\Backup\2005\Congaree.smartdiff.f1.d0.bkp
D:\Backup\2005\Congaree.smartdiff.f1.d1.bkp
D:\Backup\2005\Congaree.smartdiff.f1.d2.bkp
D:\Backup\2005\Congaree.smartdiff.f1.d3.bkp
D:\Backup\2005\Congaree.smartdiff.f1.d4.bkp
D:\Backup\2005\Congaree.smartdiff.f1.d5.bkp
D:\Backup\2005\Congaree.smartdiff.f2.bkp
To restore the initial Full + all info prior to the latest Full, T-sql script would read:
master.dbo.xp_restore_database @database = N Congaree ,
@filename = N D:\Backup\2005\Congaree.smartdiff.f1.bkp ,
@filenumber =1 ,
@with = N STATS = 10 ,
@with = N NORECOVERY ,
@affinity =0 ,
@logging =0 master.dbo.xp_restore_database @database = N Congaree ,
@filename = N D:\Backup\2005\Congaree.smartdiff.f1.d5.bkp ,
@filenumber =1 ,
@with = N STATS = 10 ,
@with = N RECOVERY ,
@affinity =0 ,
@logging = 0
exec
exec
© ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center