![]() ![]() You can run the following DBCC CHECKDB command for repairing the database.ĭBCC CHECKDB (‘database name’, REPAIR_REBUILD) If you see that the index ID is either 0 or 1, then you need to run the DBCC CHECKDB with an appropriate repair option. Here’s how to use this command:Ĭheck the database for inconsistencies by running the following command: The DBCC CHECKDB command is used to check the logical and physical integrity of all the objects in the database. If the backup is obsolete or not available, then you can use the built-in DBCC CHECKDB command in SQL Server. The first thing you can try is to restore the database file from a recent healthy backup.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |