network profile
| bio | website | |
|---|---|---|
| location | ||
| age | ||
| visits | member for | 11 months |
| seen | May 30 '12 at 21:58 | |
| stats | profile views | 1 |
|
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 |
