--- title: How To Fix Database Corruption. (LEVEL 2 ONLY) description: Clubspeed Customer Knowledge Center --- [Skip to content](https://help.clubspeed.com/clubspeed-knowledge-center/how-to-fix-database-corruption.-level-2-only#main-content) English Show submenu for translations [More support](https://help.clubspeed.com/clubspeed-knowledge-center/kb-tickets/new?hsLang=en) [![Clubspeed Logo](https://help.clubspeed.com/hs-fs/hubfs/Logo_Grey.png?width=500&height=86&name=Logo_Grey.png)](https://help.clubspeed.com/clubspeed-knowledge-center?hsLang=en) Open main navigation Close main navigation - English Show submenu for translations - [More support](https://help.clubspeed.com/clubspeed-knowledge-center/kb-tickets/new) - [Contact us](https://share.hsforms.com/1B5QyPF-YRQutaoGEnmQD5w1etz6) [Contact us](https://share.hsforms.com/1B5QyPF-YRQutaoGEnmQD5w1etz6) How can we help you? - There are no suggestions because the search field is empty. 1. [Clubspeed Customer Knowledge Center](https://help.clubspeed.com/clubspeed-knowledge-center?hsLang=en) December 6, 2024 # How To Fix Database Corruption. (LEVEL 2 ONLY) Search ### How To Fix Database Corruption. (LEVEL 2 ONLY) If you are getting an error that looks like what is printed below during FTPAutobackup or any other time, it is very possible that the database is corrupted.  **Failed to backup database BackupDatabase1 reason: SQL Server detected a logicalconsistency-based I/O error: incorrect pageid (expected 1:2142; actual 0:0). Itoccurred during a read of page (1:2142) in database ID 4 at offset 0x000000010bc000 in file 'C:\\Program Files\\Microsoft SQL Server\\MSSQL11.MSSQLSERVER\\MSSQL\\DATA\\MSDBData.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 insert a backup or restore history/detail record in the msdb database.**   **Initial Steps:** 1. **Back up the DB.** ( For this example, MSDB is the database the was corrupted) 2. Open a new query under msdb database. 3. Run: DBCC CHECKDB ('YourDatabase') WITH PHYSICAL\_ONLY **Back up the DB.** - This script checks for errors in the system. It does not adjust anything. Also the Physical only allows for the script to run faster and skip the fluff logs. - It will give you the results in the Messages and also may tell you the minimum repair option. **Repair:** There are 2 levels of repair that can be done. The above script should tell you which to run, but if it does not, run them in order. You will also have to set the database into single user mode to run the scripts.  - To set in Single\_User: Right click on DB \> Properties \> Options \> scroll to the bottom\> Change Multi\_user to Single\_User. Click OK and yes to close all sessions. Close all prior Queries. - Open a new Query Window. NOTE: In single user, you can only have one window running for single user, So the Properties is 1 window and the Query is 1 window, so 1 has to be closed for the other to open. - 2 Query Option: - DBCC CHECKDB('DB Name', REPAIR\_REBUILD) - This query tries to repair the corruption without removing any data. This is the preferred script since nothing is removed. However, it is normal for the more extreme option to be required. - DBCC CHECKDB('DB Name', REPAIR\_ALLOW\_DATA\_LOSS) - This query is highly dangerous and should only be ran by a Level 2/Developer. It involves removing data and replacing it to fix inconsistencies in order to fix corruption. Above all else a back up must be taken before running this script to ensure we can restore if necessary. - After this script is ran, copy and save the message to a file on the desktop so we can look back if needed. - Re-run DBCC CHECKDB ('YourDatabase') WITH PHYSICAL\_ONLY - You should see different results confirming the corruption was resolved. - Change the Database back to Multi\_User - Log off all terminals and restart Main. - Open a terminal and check basic functionality.   If you run into any issues, address other Level 2/Development.  - - - - ### Related Articles - [FAQs](https://help.clubspeed.com/clubspeed-knowledge-center/faqs?hsLang=en#main-content) - [Software Questions](https://help.clubspeed.com/clubspeed-knowledge-center/faqs?hsLang=en#software-questions) - [Payments Questions](https://help.clubspeed.com/clubspeed-knowledge-center/faqs?hsLang=en#payments-questions) - [Getting started](https://help.clubspeed.com/clubspeed-knowledge-center/getting-started?hsLang=en#main-content) - [Clubspeed](https://help.clubspeed.com/clubspeed-knowledge-center/getting-started?hsLang=en#clubspeed) - [Administration](https://help.clubspeed.com/clubspeed-knowledge-center/getting-started?hsLang=en#administration) - [Product Setup](https://help.clubspeed.com/clubspeed-knowledge-center/getting-started?hsLang=en#product-setup) - [Customer Experience](https://help.clubspeed.com/clubspeed-knowledge-center/getting-started?hsLang=en#customer-experience) - [Race Control](https://help.clubspeed.com/clubspeed-knowledge-center/getting-started?hsLang=en#race-control) - [Manager Controls](https://help.clubspeed.com/clubspeed-knowledge-center/getting-started?hsLang=en#manager-controls) - [Point of Sale Operations](https://help.clubspeed.com/clubspeed-knowledge-center/getting-started?hsLang=en#point-of-sale-operations) - [Venue Operations](https://help.clubspeed.com/clubspeed-knowledge-center/getting-started?hsLang=en#venue-operations) - [Race Control Operations](https://help.clubspeed.com/clubspeed-knowledge-center/getting-started?hsLang=en#race-control-operations) - [Event Calendar](https://help.clubspeed.com/clubspeed-knowledge-center/getting-started?hsLang=en#event-calendar) - [Open & Closing Shifts](https://help.clubspeed.com/clubspeed-knowledge-center/getting-started?hsLang=en#open-closing-shifts) - [Activity Setup (FEC Non Karting)](https://help.clubspeed.com/clubspeed-knowledge-center/getting-started?hsLang=en#activity-setup-fec-non-karting) - [Kart Focused](https://help.clubspeed.com/clubspeed-knowledge-center/getting-started?hsLang=en#kart-focused) - [Troubleshooting](https://help.clubspeed.com/clubspeed-knowledge-center/troubleshooting?hsLang=en#main-content) - [networking](https://help.clubspeed.com/clubspeed-knowledge-center/troubleshooting?hsLang=en#networking) - [General](https://help.clubspeed.com/clubspeed-knowledge-center/general?hsLang=en) - [Reports](https://help.clubspeed.com/clubspeed-knowledge-center/reports?hsLang=en#main-content) - [Gift Cards](https://help.clubspeed.com/clubspeed-knowledge-center/reports?hsLang=en#gift-cards) - [Integrations](https://help.clubspeed.com/clubspeed-knowledge-center/integrations?hsLang=en) - [Payments](https://help.clubspeed.com/clubspeed-knowledge-center/payments?hsLang=en) - [Email and Text Messaging](https://help.clubspeed.com/clubspeed-knowledge-center/email-and-text-messaging?hsLang=en) - [Item Management](https://help.clubspeed.com/clubspeed-knowledge-center/item-management?hsLang=en) - [Resources](https://help.clubspeed.com/clubspeed-knowledge-center/resources?hsLang=en) - [Calendar Management](https://help.clubspeed.com/clubspeed-knowledge-center/calendar-management?hsLang=en) - [Customer Management](https://help.clubspeed.com/clubspeed-knowledge-center/customer-management?hsLang=en) - [Promotions and Marketing](https://help.clubspeed.com/clubspeed-knowledge-center/promotions-and-marketing?hsLang=en) - [Updates](https://help.clubspeed.com/clubspeed-knowledge-center/updates?hsLang=en#main-content) - [Release Notes](https://help.clubspeed.com/clubspeed-knowledge-center/updates?hsLang=en#release-notes) - [Registration](https://help.clubspeed.com/clubspeed-knowledge-center/registration?hsLang=en#main-content) - [Setting up Your Registration](https://help.clubspeed.com/clubspeed-knowledge-center/registration?hsLang=en#setting-up-your-registration) - [iPads](https://help.clubspeed.com/clubspeed-knowledge-center/registration?hsLang=en#ipads) - [Products](https://help.clubspeed.com/clubspeed-knowledge-center/products?hsLang=en#main-content) - [Business Additions](https://help.clubspeed.com/clubspeed-knowledge-center/products?hsLang=en#business-additions) - [Extra Tips & Tricks](https://help.clubspeed.com/clubspeed-knowledge-center/products?hsLang=en#extra-tips-tricks) - [Setup](https://help.clubspeed.com/clubspeed-knowledge-center/products?hsLang=en#setup) - [Point of Sale](https://help.clubspeed.com/clubspeed-knowledge-center/products?hsLang=en#point-of-sale) - [Barcode](https://help.clubspeed.com/clubspeed-knowledge-center/products?hsLang=en#barcode) - [Activities](https://help.clubspeed.com/clubspeed-knowledge-center/activities?hsLang=en#main-content) - [Activity Operations](https://help.clubspeed.com/clubspeed-knowledge-center/activities?hsLang=en#activity-operations) - [Reporting](https://help.clubspeed.com/clubspeed-knowledge-center/reporting?hsLang=en#main-content) - [Sales Reports](https://help.clubspeed.com/clubspeed-knowledge-center/reporting?hsLang=en#sales-reports) - [Operational Reports](https://help.clubspeed.com/clubspeed-knowledge-center/reporting?hsLang=en#operational-reports) - [Labor Report](https://help.clubspeed.com/clubspeed-knowledge-center/reporting?hsLang=en#labor-report) - [Accounting](https://help.clubspeed.com/clubspeed-knowledge-center/reporting?hsLang=en#accounting) - [Race Operations](https://help.clubspeed.com/clubspeed-knowledge-center/reporting?hsLang=en#race-operations) - [Quickbooks Online](https://help.clubspeed.com/clubspeed-knowledge-center/reporting?hsLang=en#quickbooks-online) - [Club Booking](https://help.clubspeed.com/clubspeed-knowledge-center/club-booking?hsLang=en#main-content) - [Setup - Club Booking](https://help.clubspeed.com/clubspeed-knowledge-center/club-booking?hsLang=en#setup-club-booking) - [Operations](https://help.clubspeed.com/clubspeed-knowledge-center/club-booking?hsLang=en#operations) - [Booking Manager](https://help.clubspeed.com/clubspeed-knowledge-center/club-booking?hsLang=en#booking-manager) - [Bonus Material - Club Booking](https://help.clubspeed.com/clubspeed-knowledge-center/club-booking?hsLang=en#bonus-material-club-booking) - [Operational Flows](https://help.clubspeed.com/clubspeed-knowledge-center/operational-flows?hsLang=en) - [Food & Beverage](https://help.clubspeed.com/clubspeed-knowledge-center/food-beverage?hsLang=en) - [Speed Screen Displays](https://help.clubspeed.com/clubspeed-knowledge-center/speed-screen-displays?hsLang=en) - [Garage](https://help.clubspeed.com/clubspeed-knowledge-center/garage?hsLang=en) - [Support Task](https://help.clubspeed.com/clubspeed-knowledge-center/support-task?hsLang=en) - [Webinar](https://help.clubspeed.com/clubspeed-knowledge-center/webinar?hsLang=en) - [Playbook](https://help.clubspeed.com/clubspeed-knowledge-center/playbook?hsLang=en) [![2022-clubspeed-newsletter-header-logo](https://help.clubspeed.com/hs-fs/hubfs/2022-clubspeed-newsletter-header-logo.png?width=240&height=42&name=2022-clubspeed-newsletter-header-logo.png "2022-clubspeed-newsletter-header-logo")](https://help.clubspeed.com/?hsLang=en) Copyright © 2024, Club Speed, LLC