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
 Can't restore to new database.

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

Posted - 2013-04-25 : 11:47:33
Could you a) supply the RESTORE command used b) Supply the information from the commands on this post
http://www.sqlserver-dba.com/2012/09/sql-server-backup-file-information-needed-for-restore-sql-database.html
Jack Vamvas
--------------------
http://www.sqlserver-dba.com
Go to Top of Page

KrisLewis
Starting Member

7 Posts

Posted - 2013-04-26 : 15:20:47
I am just right clicking on restore option. I was not using a script.


quote:
Originally posted by jackv

Could you a) supply the RESTORE command used b) Supply the information from the commands on this post
http://www.sqlserver-dba.com/2012/09/sql-server-backup-file-information-needed-for-restore-sql-database.html
Jack Vamvas
--------------------
http://www.sqlserver-dba.com

Go to Top of Page

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
Go to Top of Page

davegeeit
Starting Member

11 Posts

Posted - 2013-05-02 : 02:32:23
Checkout these 2 threads would be help you.

http://www.symantec.com/connect/forums/cant-restore-sql-database-dead-server
http://stackoverflow.com/questions/6267273/how-to-restore-to-a-different-database-in-sql-server

Thanks
Go to Top of Page
   

- Advertisement -