Restore Fail in sql server 2005

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

SQL Server Administration (2005)

Restore Fail in sql server 2005

Author

Topic

seyha_moth
Yak Posting Veteran

74 Posts

Posted - 2007-01-08 : 23:42:05

Posted - 09/07/2005 : 15:32:52
--------------------------------------------------------------------------------

Hi, i need help about restore a DB
I did a backup of a database using SQL Server Management Studio, but when i try to restore my database now, i get this error:

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

Restore failed for Server 'Athenas'. (Microsoft.SqlServer.Smo)

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

What do i doing so bad??
Thanks for ur opinions and help.
Regards
------------------------------------------

seyha moth

graz
Chief SQLTeam Crack Dealer

4149 Posts

Posted - 2007-01-09 : 07:46:55

Note: This post moved to the new SQL Server 2005 Administration forum.

===============================================
Creating tomorrow's legacy systems today.
One crisis at a time.

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2007-01-09 : 13:16:23

Run RESTORE FILELISTONLY to see what backups are included in your file. Then use RESTORE DATABASE using the WITH FILE option to restore the specific backup that you want.

This is why I put only one backup in each file. I always create a new file or overwrite the old one.

Tara Kizer

seyha_moth
Yak Posting Veteran

74 Posts

Posted - 2007-01-09 : 20:41:56

Thank u for your reply

I can resolve my problem with your help.

Good Luck and Succeed your work and study

seyha moth

madhuotp
Yak Posting Veteran

78 Posts

Posted - 2007-01-09 : 23:38:08

hope u r not restoring the SQL 2000 backup in SQL 2005 machine...

Madhu

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2007-01-10 : 01:01:25

Madhu,

Why not? That works perfectly fine. You can restore a 2000 backup into 2005. That's one of the ways to perform an upgrade. The other common way is to use detach/attach.

Tara Kizer

madhuotp
Yak Posting Veteran

78 Posts

Posted - 2007-01-10 : 01:08:05

sorry... i meant other way round... ie. sql 2005 in sql 2000 my apology

madhu

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2007-01-10 : 12:17:21

Of course he's not trying to restore it in 2000, just check out the error. It's a 2005 error.

Tara Kizer

MaxHardcore
Starting Member

3 Posts

Posted - 2007-01-16 : 07:17:28

Hello,

I think I am getting a similar problem, I get this message when restoring a SQL 2005 DB.

Msg 3132, Level 16, State 1, Line 1
The media set has 2 media families but only 1 are provided. All members must be provided.
Msg 3013, Level 16, State 1, Line 1
RESTORE DATABASE is terminating abnormally.

It was backed up using whatever tool is in the full version of Server 2005. I only have the express edition and to restore I have run the filelistonly to find the logical file name. I then run a query like:

restore database new name from disk ='file location and name'
with move
'logical file name for mdf' to 'new location',
move 'logical file for ldf' to 'new location'

I have done this many times before with both 2000 and 2005, although the backup is usually done on command backup database 'database name' to disk ='location and name'.

Please help!

Cheers

Matt

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources