niklasrene (11/29/2013)
ok thanks, but i can restore them as one operation? just choose both backup files?Niklas
RESTORE DATABASE blah FROM DISK = 'BACKUPPATH\DB_FULL.BAK'
WITH STATS, NORECOVERY;
RESTORE DATABASE blah FROM DISK = 'BACKUPPATH\DB_DIFF.BAK'
WITH STATS, RECOVERY;
Of course you'll also need WITH MOVE clauses if the new database has a different path.
And the database will be restored readonly, as you set it readonly before the diff backup.