SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 General SQL Server Forums
 New to SQL Server Administration
 Can't restore to new database.
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

KrisLewis
Starting Member

USA
7 Posts

Posted - 04/25/2013 :  11:18:48  Show Profile  Reply with Quote
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
Flowing Fount of Yak Knowledge

United Kingdom
2008 Posts

Posted - 04/25/2013 :  11:47:33  Show Profile  Visit jackv's Homepage  Reply with Quote
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

Edited by - jackv on 04/25/2013 11:47:51
Go to Top of Page

KrisLewis
Starting Member

USA
7 Posts

Posted - 04/26/2013 :  15:20:47  Show Profile  Reply with Quote
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
Flowing Fount of Yak Knowledge

United Kingdom
2008 Posts

Posted - 04/27/2013 :  03:48:24  Show Profile  Visit jackv's Homepage  Reply with Quote
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 - 05/02/2013 :  02:32:23  Show Profile  Reply with Quote
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
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.06 seconds. Powered By: Snitz Forums 2000