July 27, 2006 at 10:16 am
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
July 27, 2006 at 12:40 pm
Johann
There is an old MS bug that gives the same error message. I dont think that this will help, but might be worth a read. http://support.microsoft.com/kb/833710/
Assuming that the above only applies to SQL Server 2000, then can you post the SQL that you are using to do the restore. If using the SQL Server Management Studio GUI, try doing an old fashon restore by using SQL. Finally try looking at the SQL Server Log and see if there is any additional information in there.
Hope that these things help.
Eric
July 27, 2006 at 2:26 pm
Hi eric
I already saw that article you mentioned but no help.
Is it possible to explain to me where in SQL Server 2005 should I do the Query, and where I can see the SQL Server Log?
I am new to SQL Server 2005.
Thanks a lot
Johann
July 27, 2006 at 2:33 pm
Hi eric
I tried this code:-
RESTORE FILELISTONLY
FROM DISK = 'C:\INSERO\VNE Logistics_backup_200607271528.bak'
and still gave me the error:-
Msg 3205, Level 16, State 2, Line 1
Too many backup devices specified for backup or restore; only 64 are allowed.
Msg 3013, Level 16, State 1, Line 1
RESTORE FILELIST is terminating abnormally.
July 28, 2006 at 10:15 pm
Hi, do you know how many data and log files you are trying to restore, sounds you may a lot
June 5, 2007 at 1:50 am
http://support.versionone.net/kb/article.aspx?id=10415
I am trying to restore the backup of our hosted database to my SQL Server 2000 database to set up our local system. After I specify the backup device I get the following error:
Error 3205: Too many backup devices specified for backup or restore; only 64 are allowed. RESTORE FILELIST is terminating abnormally
Cause
This is an unfortunately deceiving error message. It occurs when a SQL 2005 backup is used in a restore attempt on a SQL 2000 database. Our hosted servers run SQL 2005.
Resolution
Installing on a SQL 2005 database will eliminate this error.
If you cannot use a database running SQL 2005, VersionOne can create a SQL2000 version of your data for you to install locally using your existing system. Submit a request to VersionOne support using the Ask A Question feature.
April 18, 2008 at 12:11 am
This error will appear if you first install Sql server 2000 and then installed SQL server 2005
I installed SQL server 2000 on my machine first.
Then i just installed SQL server 2005 tools on above it to get
management studio access.
Now i am trying to restore a database on my machine from backup which
i took from server running SQL server 2005.
Trying to restore a SQL 2005 database onto a SQL 2000 instance
Explanation: It means that the user is logging into the 2000 server instance and since we are trying to restore a higher version of backup to a lower version hence the error.
April 1, 2011 at 1:50 am
I also face this problem and after researching I posted my solution here
http://www.vishalpatwardhan.com/2011/03/too-many-backup-devices-specified-for.html
and it worked for me..
cheers.....:-)
April 1, 2011 at 3:24 am
Please note: 5 year old thread.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 9 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply