Restoring in SQL 2005

Hi ,

I am trying to restore database , which is backed up from SQL 2005 ver 9.00.1399.06

to anothere machine have SQL 2005 ver 9.00.1399.00.

When I try to do a restore I am getting the following error!

Too many backup devices specified for backup or restore ; only 64 are allowed.

RESTORE HEADER ONLY is terminating abnormally . (Microsoft SQL Server, Error:3205)

Please give me some solution for this.

Did you got a solution. I am having the same problem when I move the backup from 1 server to another and try to restore|||

Yes. I guess I was restoring on the wrong server. It was not 2005. Make sure you are on the right server. We cannot restore 2005 database in 2000. My was a user error

|||that fixed it for me too....I got fooled by a 2005 upgrade issue and was actually trying to restore a 2005 db to a 2000 db server.|||that fixed it for me too.... I was trying to restore backup from 2005 to a another machine with SQL server 2005, but we found that Management Studio was showing only sql server 2000. I Confirmed it by looking at the version Number. For 2005 it was 9.0.1399 and for 2000 it was 8.0.194|||

Hi, I' m having the same problem, Im trying to restore a 2005 bkp into a another 2005, but i recive the same error have you resolve this?

thank very much and sorry about my english

|||

I'm getting this same error going from 2005 to 2005. Definatly both 2005 versions - i installed them both myself.

Anyone have any ideas?

|||This is not an SSIS issue. Moving to the SQL Server Database Engine forum.|||

the solution has already been discussed in the earlier post. You may be using SQLServer 2005Management studio but... the backup you have is from 2005 and u r trying to restore it in 2000 instance which is not possible.

Madhu

|||

Madhu K Nair wrote:

the solution has already been discussed in the earlier post. You may be using SQLServer 2005Management studio but... the backup you have is from 2005 and u r trying to restore it in 2000 instance which is not possible.

Madhu

I wish it was that simple.

I installed 2005 on a server at work and created the database in question. Then took a backup.

Then I installed 2005 on my laptop (using the same install program) and get this error when trying to restore the backup into a database on the laptop.

|||Actually, my bad. Didn't notice that the install program did not upgrade the existing sql default instance.|||http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=08.00.0760&EvtSrc=MSSQLServer&EvtID=3205&LinkId=20476|||ProdName=Microsoft+SQL+Server&ProdVer=08.00.0760&EvtSrc=MSSQLServer&EvtID=3205&LinkId=20476