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.
| Author |
Topic |
|
MaxHardcore
Starting Member
3 Posts |
 Posted - 2007-01-18 : 03:07:38
|
| Hello,I think I am getting a similar problem to a previous post, I get this message when restoring a SQL 2005 DB. Msg 3132, Level 16, State 1, Line 1The media set has 2 media families but only 1 are provided. All members must be provided.Msg 3013, Level 16, State 1, Line 1RESTORE 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!CheersMatt |
|
|
MohammedU
Posting Yak Master
145 Posts |
Posted - 2007-01-19 : 01:53:04
|
| I think backup was split into two files...You should use two backuup files...MohammedU |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-01-19 : 02:07:40
|
| Is there more than one database backup inside the file? If so, you need to specify which file to RESTORE using the WITH FILE = syntax.Tara Kizer |
|
|
|
MaxHardcore
Starting Member
3 Posts |
Posted - 2007-01-24 : 03:52:05
|
| Hi,There was only one backup in the file but the person who backed it up must of had two backup locations and only sent me one of the files! I had another backup done and it restored fine. Only problem I have now is that I can't specify where I want to backup my DB's, it will only do it to the soecified directory! Strange!Thank you for you help! |
|
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2007-01-24 : 04:05:16
|
quote:
I can't specify where I want to backup my DB's, it will only do it to the soecified directory!
What do you mean by that ? How do you backup the database ?
KH |
|
|
|
|
|
|
|
|
Error when restoring DB