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
517 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 69

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

Optimizing Cloud Backup for Low Bandwidth

With cloud storage prices going down a growing number of SMBs start to use it for backup storage. Unfortunately, business data volume rarely fits the average Internet speed. This article provides an overview of main Internet speed challenges and reveals backup best practices.

Question has a verified solution.

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

Why is this different from all of the other step by step guides?  Because I make a living as a DBA and not as a writer and I lived through this experience. Defining the name: When I talk to people they say different names on this subject stuff l…
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.
To efficiently enable the rotation of USB drives for backups, storage pools need to be created. This way no matter which USB drive is installed, the backups will successfully write without any administrative intervention. Multiple USB devices need t…

837 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