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
 SQL Server 2000 Forums
 Transact-SQL (2000)
 DataBase restoring problem

Author  Topic 

suman.reddy39
Starting Member

34 Posts

Posted - 2008-07-22 : 01:03:02
Good Morning Every buddy,
Please let me know what is this statement all about. i got it when i restored one of my database and it is not restoring the database so please let me know what dose it mean.


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


thank you all in advance.


Don't go the way Life takes you, Take the Life the way you go

subbi

khtan
In (Som, Ni, Yak)

17689 Posts

Posted - 2008-07-22 : 01:05:32
You are restoring a SQL Server 2005 backup on a SQL Server 2000


KH
[spoiler]Time is always against us[/spoiler]

Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2008-07-22 : 01:05:59
How many backups do you have in your backup file? Do you append your backups to the same file? If so, why don't you create new ones for each backup instead?

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2008-07-22 : 22:27:10
>> Too many backup devices specified for backup or restore

How did you restore db? Tried to restore from multiple backup files?
Go to Top of Page
   

- Advertisement -