Home
Topics
Microsoft SQL Server Administration
SQL Server Backup and Recovery
Restoring a SQL Server database with a corrupt data file

Restoring a SQL Server database with a corrupt data file

Greg Robidoux, Founder, Principal Database Engineer, Edgewood Solutions

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.

Requires Free Membership to View

Login

By submitting you agree to receive email communications from
TechTarget and its partners. Privacy Policy Terms of Use.

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.

More News and Tutorials

Articles

Related glossary terms

Terms for Whatis.com - the technology online dictionary
- database replication
- rollback

This was first published in September 2007

Join the conversationComment

Share

Comments

Results

Contribute to the conversation

All fields are required. Comments will appear at the bottom of the article.

Back to top

More from Related TechTarget Sites

Business Analytics
Data Center
Data Management
Data Management UK
Oracle
Content Management
Windows Server

Business Analytics
- On-the-job training turns would-be lawyer into IT director for Condé Nast
  
  Luck or fate, Justin Glatz embraces his role of helping lead the IT department for a major publishing company.
- Dashboard tools lighten burdens on business users, but not BI teams
  
  Building effective business intelligence dashboards can be a difficult task. Make sure you're ready to get the most out of your BI dashboard software.
- Note to self: Business intelligence, analytics trends to watch in 2013
  
  Businesses will tackle big data analytics, cloud BI, consumerization and collaboration in the New Year alongside beloved classics like data quality.
Data Center
- New automation, virtualization tools aid VM provisioning
  
  Increased automation and better tools are accelerating virtualization adoption and enhancing the approaches to VM provisioning.
- How time affects systems management planning
  
  Proper use of time is a critical consideration when it comes to systems management planning and responding to tasks.
- How streamlined IT service operations are doing more with less
  
  Today's IT service operations teams have adapted management techniques and employed new technology to meet budget challenges head-on.
Data Management
- 'Big data' in motion: Where does it make sense?
  
  Data architects creating operational business intelligence applications may put Hadoop 'big data' in motion using a fast messaging infrastructure.
- MDM drives Scotiabank mainframe modernization effort
  
  Mainframe-centric data models have given way to a master data management repository to support better compliance reporting at Scotiabank in Canada.
- Hadoop framework, big data systems will coexist with relational data in 2013
  
  Hadoop and NoSQL databases harness parallel processing to churn reams of big data. As 2013 dawns, interest is growing in mixing them with SQL tools.
DataManagement UK
- Big data roundtable webcast: gaining value from big data
  
  Roundtable discussion on business value of big data, chaired by Brian McKenna, Editor, SearchDataManagementUK, and featuring Mike Ferguson, Roxane Edjlali (Gartner), Joshua LeCure (GlaxoSmithKline).
- 2012 training courses: BI, data management, data warehousing
  
  Find out where to hone your business intelligence, data management and data warehouse skills with this list of training courses for 2012.
- Poor data quality: what is dirty data costing UK organisations?
  
  Poor data quality can have serious financial consequences for businesses. Read about the current state of data quality management at UK companies, including dirty data problems.
Oracle
- Advanced Oracle analytics a major focus of BI summit
  
  Advanced Oracle analytics, including big data, NoSQL and the R programming language, will be a major focus of a BI summit to be held in the Bay Area in January, according to one of its organizers.
- Pluggable Database virtualizes Oracle Database 12c
  
  Several users beta testing Oracle Database 12c say that Pluggable Database is one of its most powerful new features.
- JD Edwards upgrade: Consolidate EnterpriseOne business units
  
  Companies can consolidate their business units when doing a JD Edwards upgrade, but knowing how and when to do it isn't an easy task.
Content Management
- Best practices in implementing an information governance policy
  
  Expert Barclay Blair describes how organizations struggling with data chaos can begin an information governance policy initiative to regain control.
- Structuring an enterprise-wide information governance policy
  
  This webcast explains how organizations can structure an information governance policy to help users find important information and tame data chaos.
- Webcast: Getting started with enterprise search technology
  
  This webcast explains enterprise search technology and offers advice on setting up search initiatives to help users find important information.
Windows Server
- Finding virtualization cost savings with Hyper-V 3.0
  
  With increasing dependence on high-performing hardware, it might be tough to find cost savings. Hyper-V and virtualization may be the answer.
- Deciding whether to run Server Core in Windows Server 2012
  
  Our expert breaks down the advantages and disadvantages of deploying Server Core in Windows Server 2012.
- Internet Explorer zero-day exploit overshadows light Patch Tuesday fixes
  
  Admins begin the new year with a light Patch Tuesday that includes two critical bulletins, but they'll also want to pay attention to an exploit in IE.

All Rights Reserved,Copyright 2005 - 2013, TechTarget