Go Back   Computer Forums > General Computing > Programming
Join Computer forums Today

Thread Tools Search this Thread Display Modes
Old 08-24-2015, 05:57 AM   #1
Beta Member
Join Date: Aug 2015
Location: asda
Posts: 1
Default Recover .mdf file of SQL server

I am trying to use my database file which is in .mdf format and created on the date 14 July. Whenever i try to use my file in order to restore and update the database, it show the error message of corruption and i can't able to open them.

So i am urgent looking for a reliable solution which help to recover and restore .mdf file of SQL server.

Any suggestion will be appreciated.

georrglilvirt is offline   Reply With Quote
Old 08-24-2015, 09:08 AM   #2
Site Team
root's Avatar
Join Date: Mar 2004
Posts: 7,872
Default Re: Recover .mdf file of SQL server

I guess the first thing to ask is:

what SQL server version did the file come from?
what SQL server version are you trying to restore to?
do you have the trasaction log file (.LDF), or just the datafile (.MDF)
what process are you trying to use to attach the file?
what is the error message that you are getting?

I didn’t fight my way to the top of the food chain to be a vegetarian…
Im sick of people saying 'dont waste paper'. If trees wanted to live, they'd all carry guns.
"The inherent vice of capitalism is the unequal sharing of blessings; The inherent vice of socialism is the equal sharing of miseries."
root is offline   Reply With Quote
Old 10-04-2015, 12:09 PM   #3
Beta Member
Join Date: Oct 2015
Location: dgdfg
Posts: 1
Default Re: Recover .mdf file of SQL server

Back ups generally have the file extension ".bak". Perhaps this is a database that you have detached, in that case use attach instead of restore.
There is a way to solve the MPP viewer than it is online?
oliwialosha is offline   Reply With Quote

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off

All times are GMT -5. The time now is 08:53 PM.

Powered by vBulletin® Version 3.8.8 Beta 4
Copyright ©2000 - 2016, vBulletin Solutions, Inc.
Search Engine Friendly URLs by vBSEO 3.6.0