not able to restore from data set on sql server 2005

Posted on 2009-04-05
Last Modified: 2012-05-06
I am trying to restore a data sent from production envoriment to test envoriment SQL Server rasing following error.
we are using SQL server 2005 on win 2003 on both envoriments.

TITLE: Microsoft SQL Server Management Studio
An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)
Too many backup devices specified for backup or restore; only 64 are allowed.
RESTORE HEADERONLY is terminating abnormally. (Microsoft SQL Server, Error: 3205)
For help, click:

Open in new window

Question by:psaini172000
LVL 12

Expert Comment

by:udaya kumar laligondla
ID: 24071720 specific for SQL 2005 but, it looks like your  production envoriment is running latest SQL 2005 service pack than test envoriment.
upgrade the test environment and you will be able to restore

Author Comment

ID: 24105465
This Solution only applies to SQL server 2000

Please advice
LVL 69

Expert Comment

ID: 24125667
Any chance a MSSQL 2000 instance is running on the test box, and used in error instead of the 2005 one? All references to this error message point to MSSQL 2000 restoring a 2005 backup, or MSSQL servers with different Service Pack level.
NAS Cloud Backup Strategies

This article explains backup scenarios when using network storage. We review the so-called “3-2-1 strategy” and summarize the methods you can use to send NAS data to the cloud


Author Comment

ID: 24128859
  SQL Server 2000 is also on same machine
LVL 69

Accepted Solution

Qlemo earned 500 total points
ID: 24128867
Try to stop that MSSQL 2000 (temporary), and then restore. It should work then, or give an error about not being able to connect to the instance.
LVL 38

Expert Comment

by:Jim P.
ID: 24138736
How are you doing the restore -- with the GUI?

Can we get screen shots?
LVL 69

Expert Comment

ID: 24163473
Some progress?

Featured Post

Active Directory Webinar

We all know we need to protect and secure our privileges, but where to start? Join Experts Exchange and ManageEngine on Tuesday, April 11, 2017 10:00 AM PDT to learn how to track and secure privileged users in Active Directory.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
SSIS On fail action 5 38
tempdb log keep growing 7 34
listing SQL login names of valid databases 2 22
Shrink multiple databases at once 4 28
JSON is being used more and more, besides XML, and you surely wanted to parse the data out into SQL instead of doing it in some Javascript. The below function in SQL Server can do the job for you, returning a quick table with the parsed data.
The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.

829 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question