SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 General SQL Server Forums
 New to SQL Server Administration
 The file *.mdf is missing and needs to restore
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

dujiaojing0
Starting Member

USA
12 Posts

Posted - 06/21/2011 :  04:00:37  Show Profile  Reply with Quote
Hi,

I came across this error " The file *.mdf is missing and needs to restore" .can anyone provide me proper solution to come out of this situation? Thanks in advance.

http://www.mssqlpasswordrecovery.com

raghuveer125
Constraint Violating Yak Guru

India
285 Posts

Posted - 06/21/2011 :  05:00:28  Show Profile  Reply with Quote
YOu try to take log backup and next you need to restore from your backups till your last log backup.

In Love... With Me!
Go to Top of Page

dujiaojing0
Starting Member

USA
12 Posts

Posted - 06/22/2011 :  02:28:26  Show Profile  Reply with Quote
tks, raqhuveer125
does such kind of action would lead to data lose?
Bcz the situation is very normal before the erro message came out, and i didn't backup for 2 days.

Thanks.

http://www.mssqlpasswordrecovery.com
Go to Top of Page

raghuveer125
Constraint Violating Yak Guru

India
285 Posts

Posted - 06/22/2011 :  02:44:07  Show Profile  Reply with Quote
I need to ask some question first.

Is that full backup you took 2 days back?

Is your database in full recovery mode?

Have you taken any diff or transactional backup after taking last full backup?

Is it possible to take log backup of your database now?





In Love... With Me!

Edited by - raghuveer125 on 06/22/2011 09:53:57
Go to Top of Page

GilaMonster
Flowing Fount of Yak Knowledge

South Africa
4507 Posts

Posted - 06/22/2011 :  14:06:05  Show Profile  Visit GilaMonster's Homepage  Reply with Quote
Recovery model?
Log backups?

--
Gail Shaw
SQL Server MVP
Go to Top of Page

dujiaojing0
Starting Member

USA
12 Posts

Posted - 06/23/2011 :  00:04:17  Show Profile  Reply with Quote
quote:
Originally posted by raghuveer125

I need to ask some question first.

Is that full backup you took 2 days back?

Is your database in full recovery mode?

Have you taken any diff or transactional backup after taking last full backup?

Is it possible to take log backup of your database now?





In Love... With Me!



for ur questions:
1.yes, it is full backup.
2.yes, in full mode
3.no..i didn't do that
4.I guess not..

tks, my friend.

http://www.mssqlpasswordrecovery.com
Go to Top of Page

raghuveer125
Constraint Violating Yak Guru

India
285 Posts

Posted - 06/23/2011 :  01:53:26  Show Profile  Reply with Quote
You have only hope that you first try to take log backup
if you can able to take log backup
Then restore your latest full backup in norecovery and your log backup with recovery.

if you can't able to take log bakup
Then restore you latest full backup with recovery(Note:But if you restore this only full backup then you wont get any data stored after you full bakup)

In Love... With Me!
Go to Top of Page

GilaMonster
Flowing Fount of Yak Knowledge

South Africa
4507 Posts

Posted - 06/23/2011 :  02:48:50  Show Profile  Visit GilaMonster's Homepage  Reply with Quote
Try a tail-log backup. A regular log backup will fail (the msd is missing)

backup log .. no_truncate

REstore the full with NORECOVERY, restore the log backup

--
Gail Shaw
SQL Server MVP
Go to Top of Page

dujiaojing0
Starting Member

USA
12 Posts

Posted - 06/24/2011 :  02:34:55  Show Profile  Reply with Quote
quote:
Originally posted by raghuveer125

You have only hope that you first try to take log backup
if you can able to take log backup
Then restore your latest full backup in norecovery and your log backup with recovery.

if you can't able to take log bakup
Then restore you latest full backup with recovery(Note:But if you restore this only full backup then you wont get any data stored after you full bakup)

In Love... With Me!



Thanks raghuveer125. I guess I could only do the latest full backup recovery. Really appreciate for your help.

---------------------------------------
http://www.mssqlpasswordrecovery.com
Go to Top of Page

dujiaojing0
Starting Member

USA
12 Posts

Posted - 06/24/2011 :  02:37:26  Show Profile  Reply with Quote
quote:
Originally posted by GilaMonster

Try a tail-log backup. A regular log backup will fail (the msd is missing)

backup log .. no_truncate

REstore the full with NORECOVERY, restore the log backup

--
Gail Shaw
SQL Server MVP


Thanks for your answer, GilaMonster. Really appreciate.

---------------------------------------
http://www.mssqlpasswordrecovery.com
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.47 seconds. Powered By: Snitz Forums 2000