Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
sadaf ullah
Starting Member
2 Posts |
 Posted - 2009-10-06 : 09:55:55
|
| I want to restore database on SQL server 2005.when i restore it then it give following error after selecting database dump "An exception occurred while executing a transact-SQL statement or batc.(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)"I am new in database administration Please help.......... |
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2009-10-06 : 11:14:44
|
| Where's the DB backup from? A SQL 2008 server? That's typical of an error that you get when restoring to a lower version (2008-2005 or 2005-2000)--Gail ShawSQL Server MVP |
 |
|
|
sadaf ullah
Starting Member
2 Posts |
Posted - 2009-10-06 : 12:09:18
|
| Thank you Gilamoster for prompt action.My issue has been resolved. I am not mentioning the proper instance name of SQL Server 2005 during server connecting.Actually, Two versions are installed on my PC (SQL Server 2000 and SQL server 2005).At restoration time ,It connected with SQL server 2000 version. When i connect it with proper instance of SQL server 2005, database will be restored. |
|
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2009-10-06 : 12:53:18
|
| Yup. Thought it was something like that. Databases cannot be downgraded, a backup taken on SQL 2005 cannot be restored on SQL 2000.--Gail ShawSQL Server MVP |
|
|
|
|
|
|
Error prompt on database restoration