• Rss
  • LinkedIn
  • Youtube
  • Twitter
  • Instagram
  • English English English en
  • Deutsch Deutsch German de
Sales: +49 5251 304-800 | Support: +49 5251 304-636
NoSpamProxy
  • PRODUCT
    • NoSpamProxy Cloud
    • NoSpamProxy Protection
    • NoSpamProxy Encryption
    • NoSpamProxy Large Files
    • NoSpamProxy Disclaimer
  • RESOURCES
    • Documentation
    • Forum
    • Webcast Training
    • Training Courses
    • Support
    • Software Download
  • PARTNERS
    • Finding Resellers
    • Becoming Reseller
    • Partner Portal
  • COMPANY
    • Contact
    • Team
    • Testimonials
    • Career
    • Events
  • PRICE REQUEST
  • BLOG
  • FREE TRIAL VERSION
    • Price Request
    • Free Trial Version
  • English
    • Deutsch
  • Search
  • Menu Menu
Info Icon

How to check database integrity

How-tos all, tbc
< zurück
Zuletzt aktualisiert am:15.02.2022

This article explains how to check database integrity and repair it if necessary.

Microsoft SQL Server Management Studio is required to do this.

    1. Open Microsoft SQL Server Management Studio.
    2. Expand the Databases menu item.
    3. Click on the database “NoSpamProxyDB” and then on New Query in the upper left area. A white window now appears on the right side. To check a suspicious database for errors, you can use the following command in SQL Management Studio:
      DBCC CHECKDB ('NoSpamProxyDB')

    The next command would then correct these errors. You must set the Restrict Access mode from MULTI_USER to SINGLE_USER under Options in the database's Properties before running the command.
    DBCC CHECKDB ('NoSpamProxyDB', REPAIR_REBUILD)

    The success is checked again with the following command.
    DBCC CHECKDB ('NoSpamProxyDB')

    No red error messages should appear in the output now. If the database could not be successfully repaired and red error messages still appear, execute the more aggressive command
    DBCC CHECKDB ('NoSpamProxyDB', REPAIR_ALLOW_DATA_LOSS)

    You should also check the success with the above command afterwards. If the database cannot be repaired, you can also create a new database via the NoSpamProxy interface. The point can be found under the node “Troubleshooting”.

    If problems with the SQL Server occur often, a defect on the SQL Server is likely.

Tags:
  • all
  • tbc
25.01.2018/by Stefan Feist

SEARCH

PRODUCT

  • All Topics
  • NoSpamProxy Cloud
  • NoSpamProxy Protection
  • NoSpamProxy Encryption
  • NospamProxy Large Files

You need support?

You can find more information about NoSpamProxy in our documentation and forum.

CATEGORY

  • All Topics
  • News
  • Product
  • Tech & Support
  • Events
Subscribeto RSS Feed

NoSpamProxy

  • NoSpamProxy Cloud
  • NoSpamProxy Encryption
  • NoSpamProxy Large Files
  • NoSpamProxy Disclaimer
  • Price request
  • Team
  • Career
  • General terms and conditions
  • Data Protection Information for Business Partners and Applicants
  • Cybersecurity (PSIRT)

Partners

  • Becoming a reseller
  • Partners
  • Order Certificates
  • Newsletter

Categories

  • All topics
  • News
  • Support
  • Updates
  • Order certificates

Latest News

  • MalDoc in PDF Gefahr durch in PDFs versteckte Word Dateien Preview
    MalDoc in PDF: Danger from Word files hidden in PDFs08.09.2023 - 16:57
  • NIS2 Network and Information Systems Directive Preview
    NIS2 – What the directive means for you08.09.2023 - 09:00
  • Info Icon
    NoSpamProxy 14.1 available now04.09.2023 - 13:38
IMPRINT • EULA • Privacy Policy • Change Cookie Settings • © 2023 Net at Work GmbH
  • Rss
  • LinkedIn
  • Youtube
  • Twitter
  • Instagram
How to change the SMTP connection propertiesInfo Iconinfo iconASN1 error, not enough memory
Scroll to top