Ms Sql Error 3205
Contents |
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 too many backup devices specified for backup or restore site About Us Learn more about Stack Overflow the company Business Learn more
Too Many Backup Devices Specified Sql 2005
about hiring developers or posting ads with us Database Administrators Questions Tags Users Badges Unanswered Ask Question _ Database Administrators microsoft sql server 2000 service pack 4 Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the 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 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 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" b
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: Tuesday, April 14, http://dba.stackexchange.com/questions/10321/microsoft-sql-server-error-3205 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 or restore; only 64 http://www.sqlservercentral.com/Forums/Topic297841-149-1.aspx 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 ericI already saw that article you mentioned but n
SQL Server experts to answer whatever question you can come up with. Our new SQL Server Forums are live! Come on over! We've restricted the ability to http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=99171 create new threads on these forums. SQL Server Forums Profile | ActiveTopics | Members | Search | ForumFAQ Register Now and get your question answered! Username: Password: Save Password Forgot your Password? All Forums SQL Server 2005 Forums SQL Server Administration (2005) While restoring a database, Error:3205 Reply to Topic Printer Friendly Author Topic jeer Starting Member Pakistan 32 Posts Posted-03/17/2008: 05:45:49 Hi experts!I am too many using SQL Server 2005. while restoring a database. I got following error:"An exception occured while executing a Transct-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 )"Please guide me to resolve this problem.Thanks rmiao Flowing Fount of Yak Knowledge USA 7266 Posts Posted-03/17/2008: 23:17:19 How did you restore db? jeer Starting too many backup Member Pakistan 32 Posts Posted-03/18/2008: 00:11:30 quote:Originally posted by rmiaoHow did you restore db?I restored the database CRF by following steps:SQL Server Management Studio -> Right Click on CRF (Database Name) -> Tasks -> Restore -> Files and File Groups rmiao Flowing Fount of Yak Knowledge USA 7266 Posts Posted-03/21/2008: 20:03:04 Why choose Files and File Groups when you want to restore db? jackv Flowing Fount of Yak Knowledge United Kingdom 2179 Posts Posted-03/24/2008: 14:21:01 You can use Files and File Groups if there is an individual file (for example ) to restore. Is the current format .BAK?Jack Vamvas--------------------Search IT jobs from multiple sources- http://www.ITjobfeed.com sodeep Flowing Fount of Yak Knowledge USA 7174 Posts Posted-03/24/2008: 15:29:01 Did you backup using filegroup? sodeep Flowing Fount of Yak Knowledge USA 7174 Posts Posted-03/24/2008: 15:30:02 You really need to read BOLfor backup.restore in SQL 2005 Topic Reply to Topic Printer Friendly Jump To: Select Forum General SQL Server Forums New to SQL Server Programming New to SQL Server Administration Script Library Data Corruption Issues Database Design and Application Architecture SQL Server 2012 Forums Transact-SQL (2012) SQL Server Administration (2012) SSIS and Import/Export (2012) Analysis Serv