6 reputation
13
bio website
location
age
visits member for 1 year, 11 months
seen May 30 '12 at 21:58

Jan
29
awarded  Notable Question
Jun
19
awarded  Popular Question
May
22
revised Full and differential restore with two backup files - SQL Server 2008
Added info requested by community
May
21
awarded  Editor
May
21
revised Full and differential restore with two backup files - SQL Server 2008
added 255 characters in body
May
21
comment Full and differential restore with two backup files - SQL Server 2008
My full backup has the right name. I have no issues restoring the full database. It's the differential that has the "wrong" name. Eg: full - "DBxxx.BAK" and differential - "DBXXX_Delta.BAK" And the error I'm getting is when I try to restore the database using the differential backup after I run a full restore. Thanks for all the help. I'm sorry if I haven't been very informative so far.
May
21
comment Full and differential restore with two backup files - SQL Server 2008
thanks jgardner. Are you suggesting I use the REPLACE option? Can I use the WITH REPLACE option with the differential backup? Wouldn't that overwrite the database with the changes since the last full backup as opposed to updating them?
May
21
comment Full and differential restore with two backup files - SQL Server 2008
Yes. And no, I am using the WITH NORECOVERY option with the full database backup but WITH RECOVERY for the differential backup.
May
21
comment Full and differential restore with two backup files - SQL Server 2008
Thank you. msdn.microsoft.com/en-us/library/ms188248.aspx#TsqlProcedure mentions backing up 2 types [full and differential] to the same backup device which prompted my question about adding the diff .BAK file to the existing device. I tried using 2 different backup devices but received the error "The backup set holds a backup of a database other than the existing 'DBXXX' database." This could be because the delta backup has a different name though.
May
21
awarded  Student
May
21
comment Full and differential restore with two backup files - SQL Server 2008
Yes, they are in fact from the same database. I'm not sure why they [order processing entity] use different names. If I could ask them to use the same names on both backups, could I add them both to the same backup device?
May
21
asked Full and differential restore with two backup files - SQL Server 2008