Hi guys, I want to backup Database and restore it again, but after backup and try to restore it error message appear: SqlError The media set has 2 media families but only 1 are provided I can not to restore my database again,

Hi, Looks like back up has been taken into two files. try to back up again. Similar issue here Rajkumar

And you want to do this with SSIS? If not try one of the more appropriate SQL Server forums: http://social.msdn.microsoft.com/Forums/en-US/sqldisasterrecovery/threads http://social.msdn.microsoft.com/Forums/en-US/sqldatabaseengine/threadsPlease mark the post as answered if it answers your question | My SSIS Blog: http://microsoft-ssis.blogspot.com | Twitter

How to get the second file for Backup ???