Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 Old Forums
 CLOSED - SQL Server 2005/Yukon
 Error when trying to restore database

Author  Topic 

monfu
Yak Posting Veteran

81 Posts

Posted - 2006-07-27 : 11:53:00
Dear All,

I was given an SQL Server 2005 db on a CD, and I was supposed to restore it on my machine so that I can start working with this.

However when i try to Restore Database, the following error is cropping up:-

Too many backup devices specified for backup or restore; only 64 are allowed.
RESTORE HEADERONLY is terminating abnormally. (Microsoft SQL Server, Error: 3205)

Can anybody help please

Thanks for your help and time

Johann

nr
SQLTeam MVY

12543 Posts

Posted - 2006-07-27 : 12:35:21
Are you trying to restore on a v2005 server?
If so sounds like the backup is corrupt.


==========================================
Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.
Go to Top of Page
   

- Advertisement -