system.data.sqlclient.sqlerror:the media set has 2

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

SQL Server 2005 Forums

Transact-SQL (2005)

system.data.sqlclient.sqlerror:the media set has 2

Author

Topic

thendraljazz
Starting Member

26 Posts

Posted - 2011-12-01 : 02:05:57

Hi

while restoring database i have got this error.

system.data.sqlclient.sqlerror:the media set has 2 media families but only 1 are provided.all members must be provided

how can i rectify this?what is the solution?

can anyone help?

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2011-12-01 : 02:07:51

the error message is not complete. but it looks like backup is spanning over multiple tape drives and you've not provided entire set details while restoring

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2011-12-01 : 05:22:41

see

http://beyondrelational.com/justlearned/posts/304/sql-server-backup-database-into-multiple-files-and-restore-from-multiple-files.aspx

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources