How to find the problem of SQL database maintenance failure. View the error log of the JOB, view the historical records of the database maintenance plan, and find out the error information. use the SQL event tracker to use the SQL statement to further check dbccdbreindex (N [dbo]. [tbl view JOB error logs
View the history of the database maintenance plan and find the error information
Use SQL event tracker
Use SQL statements for further checks
Dbcc dbreindex (n' [dbo]. [tblSiteWantProd] ', n', 90, sorted_data_reorg)
Dbcc checkident ('tblsitewantprod ')
DBCC CHECKDB
Dbcc checktable
SQL error message
Create unique index ended because index id % 1 was found! . The most important primary key is ''% 2! ''.
% 1 = the number of indexes in the current table ???
% 2 = duplicate key value
View the historical records of the database maintenance plan and find out the error information. use the SQL event tracker to use the SQL statement to further check dbcc dbreindex (n' [dbo]. [tbl...