I am getting the following error while doing restore operation through SSMS.
Too many backup devices specified for backup or restore; only 64 are allowed. RESTORE HEADER ONLY is terminating abnormally (Microsoft SQL Server, Error: 3205)
In net, I found that this is due to the version problem i.e. the back up file is from SQL Server 2005 and My development Server is 2000. So the above error is coming. In microsoft site, they mentioned that to fix the problem, we have to upgrade the SQL Server Service Pack to latest Service Pack. In some other site, They mentioned that you have to upgrade your SQL Server 2000 to SQL server 2005/2008.
Now my question is that, is it not possible to restore through any commands(not with SSMS) like RESTORE DATABASE...etc?
If there is a way please tell me? What happens if I install the SPs? will they delete the data and upgrade the SQL Server to another SP? Basically I am a developer and I don't know much about restores and creation of DBs. So kindly help me please?