How to script a differential backup and restore.
Restore Full and differential:
exec master.dbo.xp_restore_database @database = 'Northwind', @filename = 'D:\backup\Northwind200608231444LiteSpeed_Full.BKP', @filenumber = 1, @with = 'NORECOVERY', @with = 'NOUNLOAD',
@with = 'STATS = 10'
exec master.dbo.xp_restore_database @database = 'Northwind', @filename = 'D:\backup\NWdifferential1.bak', @filenumber = 1, @with = 'RECOVERY', @with = 'NOUNLOAD', @with = 'STATS = 10'
Note: Full restore of Northwind must occur first, leaving the database in a 'NORECOVERY', then the restore of differential file.
Applies to all versions of LiteSpeed and SQL Server
