I have a database file that someone copied from a computer before they
formated that computer. (I know all about how to backup the database properly
and why you should verify backups are good, but it was not me and I am trying
to help this person recover as much data as possible).
Whenever I try to attach the 2005 database to a new SQL 2005 install I get a
tornpage error. My guess is that the database file was corrupted in the copy
and not repairable, but I would like to atleast try to do the
recover_with_data_loss option. The problem is that I can never get the
database to attach so that it is possible to run the dbcc checkdb.
My question is, is it possible to either repair the database unattached or
is there a way get the database attached enough for me to be able to run the
repair utility?
Thanks
btw, the error is
SQL Server detected a logical consistency-based I/O error: torn page
(expected signature: 0x55555555; actual signature: 0xa6c59cbd). It occurred
during a read of page (1:20635) in database ID 15 at offset 0x0000000a136000
in file 'C:\New Folder\StoreInfo.mdf'. Additional messages in the SQL Server
error log or system event log may provide more detail. This is a severe error
condition that threatens database integrity and must be corrected
immediately. Complete a full database consistency check (DBCC CHECKDB). This
error can be caused by many factors; for more information, see SQL Server
Books Online.
Could not open new database 'StoreInfo'. CREATE DATABASE is aborted.
(Microsoft SQL Server, Error: 824)
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment