Because of business need real-time database a few tables synchronization to another database, query every 5 seconds a such a query frequency can cause damage to the database, please? Such as the consistency error, is sql2000 database

CodePudding user response:

No, remember to install SQL2000 SP4 patches.

CodePudding user response:

No, if the fault is the best, have a good database backup plan,

CodePudding user response:

Now the problem is that every one or two months will appear the consistency error, but after the restart the server error disappears, what reason is this?

CodePudding user response:

Please check the SQL2000 SP4 patch is installed, please provide details of the error.

CodePudding user response:

Patch has been installed, error message didn't copy, restart disappeared

CodePudding user response:

What consistency error case will automatically disappear?