December 15, 2007 at 1:27 am
I have a database on server1 which is SQL Server 2005 Workgroup Edition Service Pack 2. I want to backup and restore this database on server2 which has SQL Server 2005 Standard Edition Service Pack 1.
When I try to restore the database in server2 it gives my the error
Too many backup devices specified for backup or restore; only 64 are allowed.RESTORE HEADERONLY is terminating abnormally.(Microsoft SQL Server,Error:3205)
The same error I got when I tried to restore the database in server2 which earlier had SQL Server 2000. So we installed SQL Server 2005 Standard Edition Service Pack 1 on server2 since I came to know that it is not compatible to restore database from 2005 to 2000.
I do not know why I am recieving the same error even after installing SQL Server 2005 Standard Edition Service Pack 1 in server2.
December 15, 2007 at 11:27 pm
Is SQL 2000 installed on server2? This message occurs when a 2005 database is restored to a SQL 2000 instance. You may be logging into a 2000 instance to do the restore.
more info below:
http://www.developersdex.com/sql/message.asp?p=580&r=5100689
December 16, 2007 at 12:01 am
As Adam said pls chek the version of the sql server in which you are restoring the database once again. You can make use of Select @@version.
Pls refer this thread which discusses the same issue !
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=2423812&SiteID=1
[font="Verdana"]- Deepak[/font]
December 16, 2007 at 11:46 pm
Thanks for your reply I got to know what was the problem.
They have not installed the SQL Server 2005 engine in server2 instead they have only installed GUI. So when I try to restore the database
in Management studio of 2005 it refrences the engine of SQL Server 2000.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply