Posted on: 8/3/2012 5:47:51 AM | Views : 932

Hi friends,
When I try to restore a backup created on a Microsoft SQL Server 2005 instance to a different Microsoft SQL Server instance using Microsoft SQL Server 2005 Management Studio Express, I 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)
I searched this error, from other forums they said
"You are trying to restore a Microsoft SQL Server 2005 database into Microsoft SQL Server 2000 instance."
But my target sql server is 2005 express.
How can I restore this backup ?
...

Go to the complete details ...