Comments
Sort by recent activity
alecl,
When BMC and CA did this for DB2, they did it on their own. There was no vendor API to help.
My understanding from when I worked at BMC is they worked out what a valid page should look like, and highlighted any inconsistencies. Different pages (data, index, space map, etc) each have their own formats. Where relevant, pointers to next/previous pages (eg for spacemaps, etc) were checked to ensure the target page was of the correct type. CA must have done something similar for their product but which did not violate the BMC patents, as these 2 companies were and still are very serious rivals.
The BMC product had various levels of integrity check the DBA could ask it to do. The most expensive checked that all index RIDS pointed to the right data, and that all off-page pointers went to whatever was valid.
Most installations settled on the option do do page consistency and spacemap (etc) chain checks. This was the option that added only about 5% to elapsed time. The little feedback I had about the more complex options was they were shelfware.
After about 10 years, IBM as DB2 vendor also thought that inline consistency checks were a good idea and added it to their own backup product.
The moral of all this is Red-Gate could add inline consistency checks to SQL Backup without any additional help from Microsoft. However, I have posted this request on Connect so vote for it if you want: https://connect.microsoft.com/SQLServer ... kID=340720 / comments
alecl,
When BMC and CA did this for DB2, they did it on their own. There was no vendor API to help.
My understanding from when I worked at BMC is they worked out what a valid page should look like...