Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
kerrycorcoran
Starting Member
38 Posts |
 Posted - 2008-02-06 : 09:11:02
|
| Windows Server 2003R2 w/ Sp2MS SQL 2005 w/ Sp1Currently run a weekly (full) backup and a daily (differential) backup.When I format the server and rebuild I restored the DB using the weekly (full) backup and all worked as it should.When I format the server and rebuild I attempted to restore the DB using the daily (differential) backup - I got the following error:'SPCDBDIF.BAK ' is not part of a multiple family media set. BACKUP WITH FORMAT can be used to form a new media set. RESTORE HEADERONLY is terminating abnormally. (MS SQL Server, Error: 3259)I am sure I am not using the differential file properly. What is the proper method to restore a DB and use a differential backup?Any insight appreciated.Thanks,Kerry |
|
|
kerrycorcoran
Starting Member
38 Posts |
Posted - 2008-02-06 : 09:49:30
|
| Was able to get this working. When restoring the Full backup I need to select NO RECOVERY mode than restore the Differential Backup in RECOVERY mode. |
 |
|
|
|
|
|
Differential Restore