Diff Restore Fails with SQL error 3136
However, I have done a restore from a full backup to a new db which is also now in production - and have then added this new db to the SAME backup jobs in sql backup which are doing the full, diff and log backups for the original db.
I can then successfully do a restore from diff or log of this new db.
Both dbs seem to have the same settings, recovery model etc.
the only big difference is that the diff backups for the new db are large - about 1/3 the size of the full weekly backups, wheras my original db diff backups are about 1/10 the size of the full. And the original db is larger, and by far the more active of the two. No idea if this is a clue to the cause, but there it is.
I have also done some other tests of a restore of a full backup from the original 30GB db, to a new test db, then done a full and diff backup of that db with sql backup, and have been able to restore from the diff. So what the *^(*[email protected] ?
The only other thing that may be at play here, is that the original db used to be in a cluster, and was then moved to new drives, and reattached in a new non-clustered instance of sql server.
Any suggestions would be most welcome!