I noticed that the Server_ID had a value of 1.

I did some research and found that when this happend you should drop the Server.

Then all it with a local argument:

sp_addserver...

SQLKnowItAll (8/21/2012)

---

Welsh Corgi (8/20/2012)

---

Thanks. I guess...

Thanks. I guess I have to...

I found this Script. I had two backups at 8:08:22 and 8:08:55.

The other script return one at 8:08 AM.

I was backing up a lot of Databases developing SSIS Packages and...

I just did a complete backup followed by a Differential Backup and restored both without issue.

It is almost as if sometning got backed up by that outside vendor with a...

here is the code from the Maintenance Plan.

I noticed that it is set to NOINIT and I do see an option where you can set that.

I'm not sure about the...

I'm backing up from SQL Server 2005 32bit and I'm restoring to SQL Server 2008 R2 64 bit.

I have not attempted to restore all 24 database but of the 6...

Grant Fritchey (8/20/2012)

---

Maybe I misunderstood, you're trying to apply the same differential that is matched to the first backup to a second, different backup? You can't do that. Differentials are...

BASSISControlCTLDifferential0 Seconds2012-08-20 09:59:03.000

BASSISControlCTLDifferential0 Seconds2012-08-20 07:46:09.000

BASSISControlCTLFull0 Seconds2012-08-17 08:08:55.000

I tried it with the first differential backup. Then I performed another differential backup and tried applying the second differential.

They are not copy only they are full and differential backups.

What do you mean by Is_copy_only...

I just tried restoing two more database from differntial backups, the first worked the second did not.

SQLKnowItAll (8/20/2012)

---

Welsh Corgi (8/19/2012)

---

I have a DEV/QA Server with SQL Server 2008 R2 x64 Standard Edition.

I recently upgraded the Production Server from Standard to Enterprise.

When the paperwork was submitted I...

I have a DEV/QA Server with SQL Server 2008 R2 x64 Standard Edition.

I recently upgraded the Production Server from Standard to Enterprise.

When the paperwork was submitted I questioned the licensing...

Steve Jones - SSC Editor (8/18/2012)

---

+1

Whether using script or the GUI, use norecovery.

You...

Thank you Gail!:-)