Help with Restore - 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)

Help with Restore

Author

Topic

Mix
Starting Member

15 Posts

Posted - 2006-03-25 : 15:10:33

Hello All.

Last Night, I Back'd Up my server, saved the backup file (made with SQL Enterprise Manager), Database_data.mdf and Database_log.ldf, today I formated my computer and I'm trying to recovery the database, but I'm getting the following error:

Server: Msg 3241, Level 16, State 37, Line 1
The media family on device 'D:\MuOnline.BAK' is incorrectly formed. SQL Server cannot process this media family.
Server: Msg 3013, Level 16, State 1, Line 1
RESTORE DATABASE is terminating abnormally.

Is there some solution or any other mode to run my database?
BTW, I'm using SQL Server 2000.

Thanks in advanced.

nr
SQLTeam MVY

12543 Posts

Posted - 2006-03-25 : 16:13:42

Looks like the backup file might be no good. Try attaching the .mdf and .ldf.

Did you install the server with the same service packs as before?

==========================================
Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.

Mix
Starting Member

15 Posts

Posted - 2006-03-25 : 16:38:55

I didnt got the point on "attaching the .mdf and .ldf".
I'm begginer on SQL Server. Can you please say me how step by step?

Any suggestion is accepted!

Thanks!!

Mix
Starting Member

15 Posts

Posted - 2006-03-25 : 16:40:18

Oops. forgot to awnser your question.
Yes, the server is same as before. Windows 2003 Server SP 1.

Thanks.

Mix
Starting Member

15 Posts

Posted - 2006-03-25 : 21:40:13

Sorry for my newbish and my bad english :S

I tryed to attach the .mdf and I got the error:

The file you've specified is not a valid SQL Server database file.

Any sugestion?

Thanks,
Mix

nr
SQLTeam MVY

12543 Posts

Posted - 2006-03-26 : 09:10:17

I meant the sql server verion not windows.

It's a bit of a coincidence if the backup and data files are both corrupt so I suspect something else is going on.

==========================================
Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.

Mix
Starting Member

15 Posts

Posted - 2006-03-26 : 09:33:50

The SQL Server is same as before too. With Service Pack 2.
What you recommend me to do?
I'm willing to do anything because I cant lose this database.
If I get this back, I will give you a Linux Shell / 12mbps connection as reward.

Thanks.

nr
SQLTeam MVY

12543 Posts

Posted - 2006-03-26 : 19:53:01

Try posting this in the data corruption forum.

==========================================
Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.

eyechart
Master Smack Fu Yak Hacker

3575 Posts

Posted - 2006-03-26 : 21:11:25

quote:
Originally posted by nr

Try posting this in the data corruption forum.

uh oh

http://sqlteam.com/forums/topic.asp?TOPIC_ID=63705

-ec

eyechart
Master Smack Fu Yak Hacker

3575 Posts

Posted - 2006-03-26 : 21:14:53

quote:
Originally posted by Mix

Hello All.

Last Night, I Back'd Up my server, saved the backup file (made with SQL Enterprise Manager), Database_data.mdf and Database_log.ldf, today I formated my computer and I'm trying to recovery the database, but I'm getting the following error:

Server: Msg 3241, Level 16, State 37, Line 1
The media family on device 'D:\MuOnline.BAK' is incorrectly formed. SQL Server cannot process this media family.
Server: Msg 3013, Level 16, State 1, Line 1
RESTORE DATABASE is terminating abnormally.

Is there some solution or any other mode to run my database?
BTW, I'm using SQL Server 2000.

Thanks in advanced.

have a look at this KB article http://support.microsoft.com/default.aspx?scid=KB;EN-US;Q297104

Are you sure you are running SQL 2K SP2? You might try applying the latest SQL Service pack (SP4) and then try the restore again. Or try the trace flag mentioned in the article.

-ec

nr
SQLTeam MVY

12543 Posts

Posted - 2006-03-27 : 06:58:53

It's worth a try but
"Microsoft has confirmed that this is a problem in SQL Server 2000. This problem was first corrected in SQL Server 2000 Service Pack 1."

==========================================
Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.

Mix
Starting Member

15 Posts

Posted - 2006-03-27 : 16:43:33

I installed SQL Service Pack 4 and It's still giving the same error.
PLEASE GOD HELP ME

eyechart
Master Smack Fu Yak Hacker

3575 Posts

Posted - 2006-03-27 : 16:50:39

quote:
Originally posted by Mix

I installed SQL Service Pack 4 and It's still giving the same error.
PLEASE GOD HELP ME

you need to call microsoft PSS now. Call their support line and have them help you out.

-ec

Mix
Starting Member

15 Posts

Posted - 2006-03-27 : 19:30:33

I'll call Microsoft tomorow.
BTW, U$50 via paypal for the first that helps me out with VNC.

My email: MuItj@Hotmail.com

Thanks.

Mix
Starting Member

15 Posts

Posted - 2006-03-28 : 15:29:15

Is there some way to take out "Suspect" status from a database?
If there is, I think that I can put this database back.

Thanks.

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2006-03-28 : 15:37:09

Check out sp_resetstatus in SQL Server Books Online.

Tara Kizer
aka tduggan

Mix
Starting Member

15 Posts

Posted - 2006-03-28 : 19:07:24

I made a new database called MuOnline, turned off the SQL Server, and replaced the .mdf and .ldf made my SQL Enterprise Manager by mines. So, the database became "Suspect" and I tried to use the command:

EXEC sp_resetstatus 'MuOnline'

But the query analyzer returned the error:

Prior to updating sysdatabases entry for database 'MuOnline', mode = 0 and status = 1077936153 (status suspect_bit = 0).
No row in sysdatabases was updated because mode and status are already correctly reset. No error and no changes made.

Sorry, I'm begginer on SQL Server, and THANK YOU ALL for wasting your time with me

eyechart
Master Smack Fu Yak Hacker

3575 Posts

Posted - 2006-03-28 : 19:31:31

I hope you are doing this experimentation with copies of your MDF and LDF files. IF not, you might be limiting your changes of a successful recovery.

You should call Microsoft PSS if this is that important. They are the only ones who can possibly help you now.

-ec

Mix
Starting Member

15 Posts

Posted - 2006-03-28 : 20:26:53

Yes, I am.
I can't find this Microsoft PSS. I'm from Brazil, I just got their support phone number but I couldn't call them today.

Thanks again.

eyechart
Master Smack Fu Yak Hacker

3575 Posts

Posted - 2006-03-28 : 22:08:49

quote:
Originally posted by Mix

Yes, I am.
I can't find this Microsoft PSS. I'm from Brazil, I just got their support phone number but I couldn't call them today.

Thanks again.

just call their main support, they will route you to the proper support team.

-ec

Mix
Starting Member

15 Posts

Posted - 2006-04-04 : 05:35:25

I called Microsoft support 3 nights ago and they said that the support is paid and they would return the call to say me how to pay and get the support.
I still need help with this.
Can someone say somethings for me try?

Thanks.

Next Page

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources