May 24, 2008 at 1:29 am
I had taken back up on employee from my office. Office server name is UMASHANKAR. My server name is XYZ. I had attached that back up file BY RIGHT CLICKING ::
SERVICE OBJECT-->BACKUP DEVICES-->NEW BACK UP DEVICE.
Now i create database of EMPLOYEE my server XYZ. I had tried to restore EMPLOYEE back file by right clicking
EMPLOYEE database-->TASKS-->RESTORE-->FILE OR FILEGROUP-->
To Database: Employee
Source of Restore:
From Device: Employee.bak(I had selected from file by browsing)
i had selected recent back up.
But server name in back up is Umashankar
My server name is XYZ
when i am clicking ok then i am getting this error.
Restore failed for Server 'XYZ'.(Microsoft.SqlServer.Smo)
Additional information:
|
--> An exception occured while executing a Transact-SQL statement or batch.
|
--> The media set has 2 media families but only 1 are provided. All members must be provided. All members must be provided.
RESTORE DATABASE is terminating abnormally. (Microsoft SQL Server, Error: 3132)
Plz solve this problem. I need it urgently
May 24, 2008 at 2:18 pm
My guess is that when you made the backup, there were two entries in the destination box.
If there were, then the backup was striped across the 2, and you need both of them to restore the DB. No way around it except finding the other portion of the backup.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 25, 2008 at 10:35 am
I didnt understand what u told me. Can u plz explain me in detail? Plz. Else plz tell how change server name of Back up file which is UMASANKAR to my server name XYZ
May 26, 2008 at 12:13 am
You don't need to change the server name.
When you made the backup, there's a box on the backup window that lists the backup destinations. If there is more than one entry in there, the backup is striped across the two, resulting in each containing half of the backup file.
To restore the DB if that was the case, you need both of the files.
The error's not complaining about the server name. It's telling you that there are 2 files that each contain part of the backup and you only have one of them.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 26, 2008 at 5:35 pm
If this is the first time you took backup to two files then use the code mentioned below:
Use msdb
select media_set_id from backupmediafamily
group by media_set_id
having count(media_set_id)>1
select Physical_device_name,* from backupmediafamily where media_set_id=Enter output of above query here
You will see two or more files in output just note the other file location and specify it during restore. One file location is what u already know.
Manu
May 26, 2008 at 6:04 pm
Although I do not know your specific situation, it is usually true that you should not be taking copies of the Employees database out of your office and putting them on your own server. It certainly would be a violation of Corporate Policy for almost every client I have ever worked for (hundreds of examples).
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply