Home >Backend Development >PHP Tutorial >How to find the problem of sql database maintenance failure_PHP tutorial
How to find the problem of sql database maintenance failure_PHP tutorial
- WBOYOriginal
- 2016-07-13 17:00:33792browse
Check the JOB error log
View the history of the database maintenance plan and find out the error information
Use the sql event tracker
Use the sql statement for further inspection
dbcc dbreindex(N'[dbo] .[tblSiteWantProd]', N'', 90, sorted_data_reorg)
DBCC CHECKIDENT ('tblSiteWantProd')
DBCC CHECKDB
dbcc checktable
sql Error Message
CREATE UNIQUE INDEX terminated because found Duplicate key found for index ID %1!. The most important primary key is ''%2!''.
%1=Which index of the current table may it represent? ? ?
%2=value of duplicate key
Statement：
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Previous article：Summary of PHP one-dimensional and two-dimensional array key sorting methods_PHP tutorialNext article：Summary of PHP one-dimensional and two-dimensional array key sorting methods_PHP tutorial