Error 3205 Too Many Backups
Contents |
SQL Server instance using microsoft sql server 2000 service pack 4 Microsoft SQL Server Management Studio, you get the following error: An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo) Additional information: Too many backup devices specified for backup or restore; only 64 are allowed. RESTORE HEADERONLY is terminating abnormally. (Microsoft SQL Server, Error: 3205) Cause. You are trying to restore a Microsoft SQL Server 2005 database into Microsoft SQL Server 2000 instance. Backups created with Microsoft SQL Server 2005 cannot be restored to an earlier version of SQL Server(1). Solution. Make sure you are restoring to the intended SQL Server instance. Run the following command "SELECT @@version" on the target instance of the restore operation, and make sure you are not restoring to a SQL Server 2000 instance. References. (1) Books Online 2005 (April 2006) - RESTORE (Transact-SQL) .Send mail to webmaster@sqlcoffee.com with questions or comments about this web site.
(Русский)ישראל (עברית)المملكة العربية السعودية (العربية)ไทย (ไทย)대한민국 (한국어)中华人民共和国 (中文)台灣 (中文)日本 (日本語) HomeLibraryLearnDownloadsTroubleshootingCommunityForums Ask a question Quick access Forums home Browse forums users FAQ Search related threads Remove From My Forums Answered by: Database Restoring (SQL 2008 R2) SQL Server > SQL Server Database Engine Question 0 Sign in to vote Hi I am trying to restore a database in SQL 2008 R2 and I am what I am getting instead is an error message that reads, "Too many backup devices specified for backup or restore; only 64 are allowed. RESTORE http://www.sqlcoffee.com/troubleshooting023.htm HEADERONLY is terminating abnormally. (Microsoft SQL Server, Error: 3205". Any word on how I can get about this one Monday, March 10, 2014 9:56 AM Reply | Quote Answers 0 Sign in to vote Hello, Is this issue related to cause mentioned in below article http://www.sqlcoffee.com/Troubleshooting023.htm Please mark this reply as the answer or vote https://social.msdn.microsoft.com/Forums/sqlserver/en-US/4f1954c9-dd20-4a17-9384-bc64969b4632/database-restoring-sql-2008-r2?forum=sqldatabaseengine as helpful, as appropriate, to make it useful for other readers Proposed as answer by Praveen Rayan D'sa Monday, March 10, 2014 10:11 AM Marked as answer by tracycaiMicrosoft contingent staff, Moderator Tuesday, March 18, 2014 8:55 AM Monday, March 10, 2014 10:01 AM Reply | Quote Moderator 0 Sign in to vote Hi, There is an old KB article andthe error message ismostly come with SQL Server 2000. It does not apply for SQL Server 2008, but may be worth a read. http://support.microsoft.com/kb/833710/en-us Make sure that you backup file is valid. You can run SELECT @@version to determine the version and try restoring the backup file on the compatible one. Reference: http://www.vishalpatwardhan.com/2011/03/too-many-backup-devices-specified-for.html Hope it helps. Tracy Cai TechNet Community Support Edited by tracycaiMicrosoft contingent staff, Moderator Tuesday, March 11, 2014 9:13 AM Marked as answer by tracycaiMicrosoft contingent staff, Moderator Tuesday, March 18, 2014 8:55 AM Tuesday, March 11, 2014 9:12 AM Reply | Quote Moderator All replies 0 Sign in
log in tour help Tour Start here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site About Us Learn more about Stack Overflow the company Business Learn more about hiring developers http://dba.stackexchange.com/questions/10321/microsoft-sql-server-error-3205 or posting ads with us Database Administrators Questions Tags Users Badges Unanswered Ask Question _ Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the http://saveadba.blogspot.com/2011/01/too-many-backup-devices-specified-for.html community. Join them; it only takes a minute: Sign up Here's how it works: Anybody can ask a question Anybody can answer The best answers are voted up and rise to the top Microsoft SQL Server, Error: 3205 up vote 0 too many down vote favorite I am getting this error while restoring the backup. Too many backup devices specified for backup or restore; only 64 are allowed. RESTORE HEADERONLY is terminating abnormally. (Microsoft SQL Server, Error: 3205) I have .bak file, I am using SQL Server 2008 R2. Thanks. sql-server-2008-r2 share|improve this question asked Jan 6 '12 at 20:59 Sami migrated from stackoverflow.com Jan 6 '12 at 21:27 This question came from our site for professional and enthusiast programmers. 3 Can you too many backup post the restore statement you're using? –Mithrandir Jan 6 '12 at 21:01 I have created the db and then right click on that db > tasks > restore > database. –Sami Jan 6 '12 at 21:04 While the error does not seem to indicate such, this is commonly seen when trying to restore a backup made on one version of SQL to a server running another version. What version of SQL is this backup from? –David Perry Jan 6 '12 at 21:10 1 Why did you create an empty (?) database first? Why not just go to the database node in the object explorer > restore database? This might prevent an issue with the database compatibility level. –Mithrandir Jan 6 '12 at 21:11 1 To @Mithrandir's point: Before you hit "OK" on the restore dialog, hit the "Script" button and show us the restore script it outputs. –Nick Chammas Jan 6 '12 at 21:32 add a comment| 1 Answer 1 active oldest votes up vote 1 down vote I am sorry to say, but you have a corrupt backup file. If you can, backup the database again, but use the "with verify" option to ensure it is fully functional. share|improve this answer answered Jan 7 '12 at 5:54 datagod 5,34122149 add a comment| Your Answer draft saved draft discarded Sign up or log in Sign up using Google Sign up using Facebook Sign up using Email
backup or restore; only 64 are allowed. RESTORE HEADERONLY is terminating abnormally. (Microsoft SQL Server, Error: 3205) According to Microsoft this error can occur when all the following conditions are true:You want to restore a database backup that spans across multiple backup devices, and you have not specified more than 64 backup devices. You created the database backup on a computer that is running SQL Server 2000 Service Pack 3 (SP3) (Build 2000.80.869.0) or a later build of SQL Server 2000 SP3. You try to restore the database backup on a computer that is running a build of SQL Server 2000 SP3 that is earlier than 2000.80.869.0. Ref : http://support.microsoft.com/kb/833710 But today I was trying to restore a database backup that was taken from SQL Server 2005 instance and I restoring this to a SQL Server 2000 instance and I got this error. Unfortunately, I had split the backup into 10 stripes because the database was pretty large. So my initial thoughts suggested that this is due to the fact that I had 10 striped backup files. So I spent sometime in creating a new backup with just one file. But the error kept coming. Upon further research, I found that a lot of folks saw this error when they tried to restore a backup from a 2005 instance to database on 2000 instance. So the error seems to be misleading in some ways. Due to the fact that the structure of the backup header files were changed in SQL Server 2005, you can not restore it to a SQL Server 2000 instance. It might be worth trying the detach-attach method to work around this problem. One could also try to use the SSIS export/import method to get the data to a 2000 instance. For now, I decided to upgrade my instance to 2005 and restore the DB. Ref : http://social.msdn.microsoft.com/forums/en-US/sqldatabaseengine/thread/46e3ecf9-6eab-4aa0-9453-11e7269efb6e/ http://dbaspot.com/forums/sqlserver-server/378212-error-too-many-backup-devices-specified.html http://www.sqlcoffee.com/Troubleshooting023.htm Posted by Kaykay at 3:38 PM Email ThisBlogThis!Share to TwitterShare to FacebookShare to Pinterest Labels: Backup and Restore 2 comments: AnonymousJanuary 15, 2013 at 5:14 AMhiiiiiithis is dinesh from india i am using sql 2005 and 2000 i have create a backup in sql 2005 and i want restore this backup in 2000 sql server.but whil i try to restore it there is an error come error 3205 too many backup devices specified for backup or restore only 64 are allowed, RESTORE FILELIST is te