Solved

Can I repair an SQL 2008 R2 database that gives the attached error when I attempt to make a backup?

Posted on 2011-03-08
5
515 Views
Last Modified: 2012-05-11
I want to make a copy of an SQL DB but get the attached error when I attempt to backup in SQL Management Studio. Is there a way to repair this DB?
Picture-2.png
0
Comment
Question by:PDSWSS
5 Comments
 
LVL 15

Expert Comment

by:Aaron Shilo
ID: 35079810
hi

did you DEattach the db before coping the files ?
if not then you most do this.
or just backup the database and restore.
0
 

Author Comment

by:PDSWSS
ID: 35079862
Please read my post more carefully. I attempted to backup the database but got the attached error message when I tried.

I then attempted to copy the file (detached file) and  when I tried to paste onto the backup drive would get an error. It appears that the db may be corrupted and I wanted to know if there was a way to repair it.

I need to wipe the RAID system clean and reinstall all software and would like to be able to save this DB. Thanks
0
 
LVL 14

Assisted Solution

by:Daniel_PL
Daniel_PL earned 250 total points
ID: 35079892
Can you try to backup database to other disk?
Please run DBCC CHECKDB (<your db name>) on that database.
You can also run it:
USE <your db name>
DBCC CHECKDB ()

Please check output for any errors.
0
 
LVL 68

Accepted Solution

by:
Qlemo earned 250 total points
ID: 35080680
Your data file is damaged on NTFS level (not harddisk), so your only hope is that you have a valid backup already, with transaction logs backed up, too. You can also try to perform a chkdsk - that might repair a minor issue, but more likely it will not help.
There might be 3rd-party tools for repairing, but nothing coming with MSSQL or your OS.
0
 

Author Comment

by:PDSWSS
ID: 35110176
Although I was not able to save this file and test these solutions, I will split the 500 points between Daniel_PL and Qlemo. Thanks
0

Featured Post

Microsoft Certification Exam 74-409

VeeamĀ® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
need help in sql 4 66
Help Parsing a String with SQL Syntax 23 28
SQL Pivot add row totals 2 12
Sql Query with datetime 3 12
Create your own, high-performance VM backup appliance by installing NAKIVO Backup & Replication directly onto a Synology NAS!
Workplace bullying has increased with the use of email and social media. Retain evidence of this with email archiving to protect your employees.
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.
Viewers will learn how the fundamental information of how to create a table.

910 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

23 Experts available now in Live!

Get 1:1 Help Now