Restoring a SQL Server database with a corrupt data file

Edgewood Solutions

Find out how to restore data from a corrupt database.

Step 2 of 2:

Can a SQL Server database be restored if the data file is corrupt? The problem is, we do not have any valid backups but do have the current data file and the log file.

If you have the mdf and ldf files and they are not corrupt you can do an "attach" to connect the database to SQL Server. If the files are corrupt and you do not have a good backup, there is not much you can do. There are some companies out there that say they can recover the data. So, I would look them up on the Internet to see what they can do for you.

This was last published in September 2007

Dig Deeper on SQL Server Backup and Recovery

All
News
Get Started
Evaluate
Manage
Problem Solve

PRO+

Content

Find more PRO+ content and other member only offers, here.

E-Handbook

Shining a light on SQL Server storage tactics

Related Q&A; from Greg Robidoux

SQL Server error message: "Server out of memory"

Avoid restoring your SQL Server database to solve the SQL Server error message "server out of memory." The problem could be the memory settings.continue reading

Back up tables from SQL Server 2005 database to a file

Back up tables from a SQL Server database to a file with these commands.continue reading

Synchronize databases on two separate active servers

Synchronize databases on separate servers without using SANs. Learn options for server failover in SQL Server including log shipping, database ...continue reading

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

Meet all of our SQL Server experts

View all SQL Server questions and answers

SearchBusinessAnalytics

Sports data analytics isn't always a slam dunk

The growing trend of analytics in sports has caused much debate, and even though data-driven decisions can provide some benefits,...

Visualized data aids in building, updating predictive models

Data scientists at Capital One and BuildingIQ use data visualizations to help guide their efforts in developing, training and ...

Four steps to make a data visualization project succeed

Data scientist Jennifer Shin offers advice on how to manage a data visualization project and create effective visuals that meet ...

SearchDataCenter

What to know before taking the CCNP Data Center exam

With a focus on data center network implementation and support, CCNP Data Center is a subset certification from Cisco. But is ...

Advisory Board Q&A;: Three edge data center predictions

With the rise of IoT, more organizations are considering an edge data center. The SearchDataCenter Advisory Board predicts the ...

IT career advice to wow future employers

There are many ways to land your dream IT job, but knowing what interviewers are going to ask, what new roles are emerging and ...

SearchDataManagement

Big data governance steps into IT spotlight as architectures expand

Effectively governing the data stored in different systems across big data architectures is emerging as one of the keys to a ...

Big data architectures face big hurdles with technology integration

Hadoop and all the related technologies surrounding it enable organizations to design big data environments that meet their ...

Effective data visualization crystallizes a company's crystal ball

What's in your toolbox? October's issue of Business Information turns the tables and puts that burning question to ...

SearchAWS

Custom AWS metrics maximize use of CloudWatch Logs

Unlike standard app dev methods, serverless computing with AWS Lambda does not enable easy debugging. These tools can help ...

Implementing DevOps in AWS is part mindset, part tool set

DevOps relies on both an organizational shift in thinking and automation tools; without one or the other, the approach will fail.

With Amazon cloud storage, know what's in store

Amazon cloud storage comes in a variety of shapes and sizes. There's Amazon Simple Storage Service (S3), Glacier and Elastic ...

SearchOracle

Oracle cloud architecture push spawns new tools, issues for users

The cloud is now Oracle's top strategic priority, and users have to decide if they're ready to migrate. This guide offers a ...

Shards of Oracle: Distributed performance improved in Oracle 12c Release 2

Database sharding appears in the newly available Oracle 12c Release 2. With it, the flagship database takes a big step toward ...

Oracle 12c Release 2 goes cloud-side first

Oracle 12c Release 2 is going to the cloud first, in keeping with Larry Ellison's campaign to do cloud better than others. AWS ...

SearchContentManagement

Human data at the center of customer success

Utilizing human data in the right way can give companies new insights and a competitive edge in customer experience.

Six ECM video features missing in most enterprise solutions

Enterprise users are looking for new ways to enrich their data assets. Expert Reda Chouffani outlines the 6 ECM video features ...

Why Microsoft Azure is the backbone of the Office 365 subscription

With cloud-based services becoming more and more essential to collaboration and productivity for companies, the Office 365 ...

SearchWindowsServer

Microsoft Azure Stack tweaks causing delays, IT pros still hopeful

Improvements to Microsoft's Azure Stack hybrid cloud platform are coming slower than anticipated, but IT shops still hope to get ...

Microsoft slates Windows Server 2016 availability for mid-October

Microsoft dedicated its opening keynote to the benefits of Azure, but IT pros say the company's on-ramp to the cloud still needs ...

These Windows configuration management tools can prevent mishaps

It's a challenge to limit downtime and speed up deployments in the data center. Configuration management tools can help IT ...

Dig Deeper on SQL Server Backup and Recovery

E-Handbook

Related Q&A; from Greg Robidoux

Have a question for an expert?

0 comments

E-Mail

Username / Password

Password

Forgot Password?

Your password has been sent to: