Wednesday, March 7, 2012

Error with restoring Backups

I recieved 4 database's that were backed up from our client. They are using SQL Server 2000 and each of the files has no extension.

When attempting to restore a database of the same name in SQL Server Express 2k5 I recieve the following error.

System.Data.SqlClient.SqlError: The media set has 2 media families but only 1 are provided

Is there a way to restore the backup without the log backup?

Thank you
-Robert-


Hi,

i just guess that you don′t have a full backup specified here. YOu will have to pick the Full backup and apply the Diff. backups or transactional backups afterwards.

HTH, Jens K. Suessmeyer.


http://www.sqlserver2005.de

No comments:

Post a Comment