Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Administration
 Restore database

Author  Topic 

srikanth19
Starting Member

6 Posts

Posted - 2011-02-16 : 15:27:47
Hi everyone,I get the following error when i try to restore a database from once server to another server
Restore failed for server"Server name"(Microsoft.sqlserver.smo)

Additional information
System.data.sqlclient.sqlerror
The volume on device "device name" is not a part of a multiple family media set.BACKUP FORMAT can be used to form a new media set(Microsoft.sqlserver.smo)

And what exactly the error number 3259??
Can anyone please help me how to overcome through these errors
Thanks a ton in advance

m.nagasrikanth"

jeffw8713
Aged Yak Warrior

819 Posts

Posted - 2011-02-16 : 16:27:23
When you are specifying the restore you are telling the system to use multiple files, but the backup file you are specifying is not part of a multi-file (striped) backup.

You need to change the restore to process just that backup file.

Jeff
Go to Top of Page

srikanth19
Starting Member

6 Posts

Posted - 2011-02-16 : 16:32:36
Thanks a lot jeff...........
but how can i change the restore for that particular backup file?

m.nagasrikanth"
Go to Top of Page

jeffw8713
Aged Yak Warrior

819 Posts

Posted - 2011-02-16 : 18:20:44
I don't understand your question - how are you specifying the backup file when you do the restore? If you are doing this from the GUI, make sure you only have the one backup file specified. You can also click on the Script button at the top of the windows and generate the code that will be run.

If you post that, we can see what it is trying to do and where you have specified multiple files.

Jeff
Go to Top of Page

srikanth19
Starting Member

6 Posts

Posted - 2011-02-16 : 18:41:50
Thanks jeff
i did the restore successfully

m.nagasrikanth"
Go to Top of Page
   

- Advertisement -