Error While Restoring - SQL Server Forums

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 2000 Forums

SQL Server Administration (2000)

Error While Restoring

Author

Topic

a.rameshk
Starting Member

19 Posts

Posted - 2007-07-30 : 05:06:11

One BackupFile is there in a server. Name is Ramesh.BAK.
I copied this .BAK file and trying to Restore it in my Local SQL Server 2000 using the below syntax.

RESTORE DATABASE SMDR
FROM DISK='F:\Ramesh.BAK'
WITH MOVE 'Ramesh_Data' TO 'F:\Ramesh_Data.mdf',
MOVE 'Ramesh_Log' TO 'F:\Ramesh_log.ldf'

If i use above syntax i am getting the below error:
Server: Msg 3132, Level 16, State 1, Line 1
The media set for database 'Ramesh' has 2 family members but only 1 are provided. All members must be provided.
Server: Msg 3013, Level 16, State 1, Line 1
RESTORE DATABASE is terminating abnormally.

And if i user another syntax(below one) i am getting the another error:
RESTORE DATABASE ramesh
FROM DISK='F:\Ramesh.BAK',
DISK='E:\Ramesh.BAK'
WITH RECOVERY

Error:Server: Msg 3201, Level 16, State 2, Line 1
Cannot open backup device 'E:\Ramesh.BAK'. Device error or device off-line. See the SQL Server error log for more details.
Server: Msg 3013, Level 16, State 1, Line 1
RESTORE DATABASE is terminating abnormally.

What is the solution for this problem.Can anybody please clarify me.

Thanks & Regards
Ramesh.M

a.rameshk
Starting Member

19 Posts

Posted - 2007-07-30 : 05:08:34

After copying the .BAK backup file . I pasted it in my Local F Drive.
And from there i am doing the above process

b.veenings
Yak Posting Veteran

96 Posts

Posted - 2007-07-30 : 05:09:57

did you installed the backup as a device on server object ?

Need an SQLDB consultant?
check www.veeningsengineering.nl

spirit1
Cybernetic Yak Master

11752 Posts

Posted - 2007-07-30 : 05:53:26

RESTORE DATABASE ramesh
FROM DISK = N'F:\Ramesh.BAK'
WITH FILE = 1

_______________________________________________
Causing trouble since 1980
blog: http://weblogs.sqlteam.com/mladenp

donpolix
Yak Posting Veteran

97 Posts

Posted - 2007-07-30 : 06:07:28

I'm guessing you put both the backup pieces on drive F, while your restore command specifies drive E for the other part (DISK='E:\Ramesh.BAK').

Donn Policarpio

Kristen
Test

22859 Posts

Posted - 2007-07-30 : 07:05:49

See

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=55210&SearchTerms=RESTORE%20syntax%20/%20example

which will help you interrogate the Backup file to find out what it contains, and then construct a RESTORE command to restore it to the new location, change the logical names, re-synchronise the Users, etc.

Kristen

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2007-07-30 : 23:13:33

Looks like the db was backed up to two files, you need both of them for restoring.

spirit1
Cybernetic Yak Master

11752 Posts

Posted - 2007-07-31 : 04:44:15

have you tried my suggestion?

_______________________________________________
Causing trouble since 1980
blog: http://weblogs.sqlteam.com/mladenp

a.rameshk
Starting Member

19 Posts

Posted - 2007-07-31 : 05:05:57

Hi Spirit,
I tried your suggestion. Getting the same error.

Server: Msg 3132, Level 16, State 1, Line 1
The media set for database 'RAMESH' has 2 family members but only 1 are provided. All members must be provided.
Server: Msg 3013, Level 16, State 1, Line 1
RESTORE DATABASE is terminating abnormally.

spirit1
Cybernetic Yak Master

11752 Posts

Posted - 2007-07-31 : 05:13:51

aha, then rmiao is right.

_______________________________________________
Causing trouble since 1980
blog: http://weblogs.sqlteam.com/mladenp

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources