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 |
|
KrisLewis
Starting Member
7 Posts |
 Posted - 2013-04-25 : 11:18:48
|
| I have just created a new database. I want to restore to this new database but I am getting the following error:System.Data.SqlClient.SqlError: The media loaded on "C:\Transfer\DemoTemplate" is formatted to support 1 media families, but 2 media families are expected according to the backup device specification. (Microsoft.SqlServer.Smo)I was restoring from a database that has filegroups in it. I just want to backup and not include a certain filegroug, and than restore to a new database.This is a continuation of my previous post. I want to put a large table into a filegroup, out of my database. So i can create a new database that is identical minus that table. So I can transfer the database faster since it will be a lot smaller. Is there a way to do this? |
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
|
|
KrisLewis
Starting Member
7 Posts |
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2013-04-27 : 03:48:24
|
| Yes, but depending on what file you are trying to restore and how you want to restore , than you need to select various options. You can see what script is generated by clicking on the Generate Script button at the top - before you submit the action. Did you add a location or did you replace the location with the new one?If you added a location then you're asking the backup to be striped across the two devices, half in each. You'd need both for a restore. If you want to change the location, you need to remove the listed location and add the new one. Jack Vamvas--------------------http://www.sqlserver-dba.com |
 |
|
|
davegeeit
Starting Member
11 Posts |
|
|
|
|
|
Can't restore to new database.