Microsoft Sql Error 3205 Too Many Backup Devices
Contents |
(Русский)ישראל (עברית)المملكة العربية السعودية (العربية)ไทย (ไทย)대한민국 (한국어)中华人民共和国 (中文)台灣 (中文)日本 (日本語) HomeLibraryLearnDownloadsTroubleshootingCommunityForums Ask a question Quick access Forums home Browse forums users FAQ Search related threads Remove From My Forums
Too Many Backup Devices Specified For Backup Or Restore Only 64 Are Allowed
Answered by: Database Restoring (SQL 2008 R2) SQL Server too many backup devices specified sql 2005 > SQL Server Database Engine Question 0 Sign in to vote Hi I am trying
Microsoft Sql Server 2000 Service Pack 4
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 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 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, Moder
up Recent PostsRecent Posts Popular TopicsPopular Topics Home Search Members Calendar Who's On Home » SQL Server 2005 » SQL Server 2005 General Discussion » Error when trying to restore a database on... Error when trying to restore a database on SQL Server 2005 Rate Topic Display Mode Topic Options Author Message Johann MontfortJohann Montfort Posted Thursday, July 27, 2006 10:16 AM SSC-Enthusiastic Group: General Forum Members Last Login: https://social.msdn.microsoft.com/Forums/sqlserver/en-US/4f1954c9-dd20-4a17-9384-bc64969b4632/database-restoring-sql-2008-r2?forum=sqldatabaseengine Tuesday, April 14, 2009 6:45 AM Points: 151, Visits: 107 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 http://www.sqlservercentral.com/Forums/Topic297841-149-1.aspx or restore; only 64 are allowed.RESTORE HEADERONLY is terminating abnormally. (Microsoft SQL Server, Error: 3205)Can anybody help pleaseThanks for your help and timeJohann Post #297841 Eric PetersonEric Peterson Posted Thursday, July 27, 2006 12:40 PM SSC-Enthusiastic Group: General Forum Members Last Login: Wednesday, March 24, 2010 1:57 PM Points: 182, Visits: 65 JohannThere 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 Post #297894 Johann MontfortJohann Montfort Posted Thursday, July 27, 2006 2:26 PM SSC-Enthusiastic Group: General Forum Members Last Login: Tuesday, April 14, 2009 6:45 AM Points: 151, Visits: 107 Hi
and shrinking the transaction log Backing up the tail Inside the transaction log So, what's in a backup file? Test: A full backup does not http://www.sqlbackuprestore.com/error3205.htm contain deleted data Verifying backup files Verifying backup files on a budget http://saveadba.blogspot.com/2011/01/too-many-backup-devices-specified-for.html Cumulative backups Recovering individual tables Backup and restore history details Backup reads and writes Speeding up backups Backup speed details Speeding up restores Restore state affects speed too Backup and restore rights Log shipping Log shipping in SQL Server 2000 Setting up log shipping using Enterprise Manager too many Checking the set up Failover Log shipping in SQL Server 2005 Setting up log shipping using Management Studio Checking the set up Log shipping status report Failover Log shipping in SQL Backup Using the CopyTool utility Failover 3rd party backup applications VDI VDI versions VDI errors SQL Backup - beyond compression Restoring a chain of transaction log backups Restoring to too many backup the latest possible state Backing up multiple databases Backup retention Making a copy of the backup file Backup file naming conventions Restoring the latest backup set Network resilience Encryption Integrated database verification Database file relocation Improved backup retention RESTORE HELP High-availability group support Common SQL Backup issues Installation checklist Setting up rights Configuring service rights Backup data Hanging issues Common backup and restore errors Error 3201 - when performing a backup to a network share Full database backup file is larger than database size Error 3205 - Too many backup devices specified for backup or restore Error 4305 - an earlier transaction log backup is required Bringing a database that is in recovery or read-only mode online Using bulk-logged recovery model but transaction log backup is still large Error 14274 - unable to delete SQL Server Agent job Error messages when restoring from different versions of SQL Server. Pending vdi error codes Restore speed details Help, my transaction log file is huge! Mirror or log ship What You receive error 3205 when attempting to restore a dat
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-1