Reputation
424
Top tag
Next privilege 500 Rep.
Access review queues
Badges
3 9 26
Impact
~95k people reached

  • 0 posts edited
  • 0 helpful flags
  • 8 votes cast
Jan
6
awarded  Famous Question
Dec
30
awarded  Famous Question
Dec
18
awarded  Popular Question
Dec
12
awarded  Popular Question
Nov
21
awarded  Popular Question
Oct
30
accepted Restoring a differential database file “the backup set holds a backup of a database other than the existing”
Oct
30
comment Restoring a differential database file “the backup set holds a backup of a database other than the existing”
Yeh weird hey! I just did it again- restored the full backup with norecovery and then attempted to apply the differential and same error. The backup files do have multiple databases in them and the full restore is done through SSMS whilst the differential through script, however I can't see how any of that should make a difference.
Oct
30
comment Restoring a differential database file “the backup set holds a backup of a database other than the existing”
Hi Ben. Yes I did specify NO RECOVERY (which made the db inaccessible as expected).
Oct
30
comment Restoring a differential database file “the backup set holds a backup of a database other than the existing”
Thanks @BenThul- fixed.
Oct
30
revised Restoring a differential database file “the backup set holds a backup of a database other than the existing”
edited body
Oct
30
revised Restoring a differential database file “the backup set holds a backup of a database other than the existing”
added 284 characters in body
Oct
30
comment Restoring a differential database file “the backup set holds a backup of a database other than the existing”
I've just checked and they are an exact match. I thought this at first, so I ran a full backup, created a table and then ran a differential. The differential was only a few megabytes big so I assumed it was attached to that Differential.
Oct
29
revised Restoring a differential database file “the backup set holds a backup of a database other than the existing”
deleted 168 characters in body
Oct
29
asked Restoring a differential database file “the backup set holds a backup of a database other than the existing”
Oct
14
awarded  Nice Question
Oct
13
awarded  Yearling
Sep
25
awarded  Popular Question
Sep
15
awarded  Popular Question
Sep
3
awarded  Notable Question
Aug
26
awarded  Popular Question