Section 2: Getting Started > Working With Microsoft SQL Server Databases

Repairing a Microsoft SQL Server Database

The database repair process analyzes an At Your Service Microsoft SQL Server database for data integrity in order to resolve potential data problems.

Before repairing the database, you must ensure that all other users are out of the database. This includes temporarily closing the At Your Service – Internet Utility (see Exiting the Internet Utility). To analyze and repair the open database file, first close all windows within the main program shell and then select File  Repair Database from the main menu. Only the program administrator (see User Security) may repair the database. A prompt will verify the request before proceeding.

(See also Repairing and Compacting an Access Database, and Repairing a MySQL Database.)


Microsoft SQL Server Database Administration