The file *.mdf is missing and needs to restore

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

General SQL Server Forums

New to SQL Server Administration

The file *.mdf is missing and needs to restore

Author

Topic

dujiaojing0
Starting Member

12 Posts

Posted - 2011-06-21 : 04:00:37

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.

[url]http://www.mssqlpasswordrecovery.com[/url]

raghuveer125
Constraint Violating Yak Guru

285 Posts

Posted - 2011-06-21 : 05:00:28

YOu try to take log backup and next you need to restore from your backups till your last log backup.

In Love... With Me!

dujiaojing0
Starting Member

12 Posts

Posted - 2011-06-22 : 02:28:26

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.

[url]http://www.mssqlpasswordrecovery.com[/url]

raghuveer125
Constraint Violating Yak Guru

285 Posts

Posted - 2011-06-22 : 02:44:07

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!

GilaMonster
Master Smack Fu Yak Hacker

4507 Posts

Posted - 2011-06-22 : 14:06:05

Recovery model?
Log backups?

--
Gail Shaw
SQL Server MVP

dujiaojing0
Starting Member

12 Posts

Posted - 2011-06-23 : 00:04:17

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.

[url]http://www.mssqlpasswordrecovery.com[/url]

raghuveer125
Constraint Violating Yak Guru

285 Posts

Posted - 2011-06-23 : 01:53:26

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!

GilaMonster
Master Smack Fu Yak Hacker

4507 Posts

Posted - 2011-06-23 : 02:48:50

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

dujiaojing0
Starting Member

12 Posts

Posted - 2011-06-24 : 02:34:55

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

dujiaojing0
Starting Member

12 Posts

Posted - 2011-06-24 : 02:37:26

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

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources