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.
| 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 serverRestore 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 errorsThanks a ton in advancem.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 |
 |
|
|
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" |
|
|
|
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 |
|
|
|
srikanth19
Starting Member
6 Posts |
Posted - 2011-02-16 : 18:41:50
|
| Thanks jeffi did the restore successfullym.nagasrikanth" |
|
|
|
|
|
|
Restore database