• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 527
  • Last Modified:

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

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
PDSWSS
Asked:
PDSWSS
2 Solutions
 
Aaron ShiloChief Database ArchitectCommented:
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
 
PDSWSSAuthor Commented:
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
 
Daniel_PLDB Expert/ArchitectCommented:
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
 
QlemoDeveloperCommented:
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
 
PDSWSSAuthor Commented:
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

The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now