Question

Best way to sort out a Corrupt Repository Database?

Administration

Updated January 28, 2016

asked on January 27, 2016

Hi,

I am getting errors in event viewer and it points to the repository .mdf file. I have done a DBBC CheckDB and get a few errors and corrupt pages.

Is there a way of easily repair the Database or is the option of exporting a briefcase then start fresh with a new Database?

I have seen many things on google, but maybe best to try our own experts :)

Thanks

Gert

1 0

Replies

replied on January 27, 2016

When was your last good backup? Can you restore from that?

is the option of exporting a briefcase then start fresh with a new Database

That seems like a last resort. You'll lose users, permissions, volumes, etc.

0 0

replied on January 27, 2016

Backups are daily but seem as it has been happening for a while and went unnoticed. Running Sql Express 2008R2. It is

This is the error msg:

SQL Server detected a logical consistency-based I/O error: incorrect checksum (expected: 0xc27d7f5f; actual: 0xc23d7f5f). It occurred during a read of page (1:472443) in database ID 5 at offset 0x000000e6af6000 in file 'C:\Program Files\Microsoft SQL Server\MSSQL10_50.LASERFICHE\MSSQL\DATA\repos.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.

0 0

replied on January 28, 2016

If DBCC CHECKDB returned errors you can try running DBCC CHECKDB ('DBNAME', REPAIR_ALLOW_DATA_LOSS) to see if you can repair the database otherwise you will need to restore from the last known good backup.

0 0

You are not allowed to follow up in this post.

Question

Question

Best way to sort out a Corrupt Repository Database?

Replies

Sign in to reply to this post.