0

I want to Backup/Restore our managed metadata managed service's database from live to test which are both sharepoint 2013 farms. So i did these steps:-

1- Inside the live database i select the related managed metadata database >> right click on it >> Tasks >> Back Up... >> and i got a file named ttd.bak of size 1.9 MB, as follow:- enter image description here

2- then inside our test database , i created a new database with the same name as the live >> right click on the "Databases" >> click on "Restore Database" >> i select the new database and the ttd.back, but i got this error:-

TITLE: Microsoft SQL Server Management Studio
------------------------------

Restore failed for Server 'WIN-SPDEV'.  (Microsoft.SqlServer.SmoExtended)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=10.50.4000.0+((KJ_PCU_Main).120628-0827+)&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Restore+Server&LinkId=20476

------------------------------
ADDITIONAL INFORMATION:

System.Data.SqlClient.SqlError: The media set has 2 media families but only 1 are provided. All members must be provided. (Microsoft.SqlServer.Smo)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=10.50.4000.0+((KJ_PCU_Main).120628-0827+)&LinkId=20476

------------------------------
BUTTONS:

OK
------------------------------

as follow:- enter image description here

so can anyone advice on this? now our live environment (which i backup-ed the DB from) has the SP database on separate VM, while our test server (where i am trying to restore the DB) has the database server inside the same VM as sharepoint.. not sure if this is related to my problem?

2

this is becuase of the way you are performing the backups of your db.

  1. When you make the backup, change the Backup Set Name.
  2. Remove all of the destinations listed, and add 1 new destination.

  3. Do a full backup.

  4. Restore this back file . Source

Also the answer here to understand it.https://social.msdn.microsoft.com/Forums/sqlserver/en-US/abf50e00-c9b0-4809-9e61-43ed8a53e968/the-media-set-has-2-media-families-but-only-1-are-provided

  • i did not get your points...can you please explain the cause and the solution? – SharePoint TestDev May 2 at 22:19
  • now i repeated the backup again, and i got a file which is almost double the size of the previous file and when i restore it , it worked well, so i am not sure what is going on!! – SharePoint TestDev May 2 at 23:51
  • 1
    Maybe you originally were splitting backup into 2 separate files? – Marek Sarad May 3 at 13:03
  • @Marek Sarad Thanks for the reply... i do not think i have specified to split it into 2 separate files... can you advice how an export inside the sql management studio can be defined to split the backup file into 2 separate files? and why would a backup task cause the backup file to be splitting into 2 file,, i do not think this was the case.. – SharePoint TestDev May 3 at 23:50

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.