Subject Max metadata changes allowed
Author Chris Bland
Hi,

I am looking for some more info on this:

####
From a previous message:

>So I do get more from a backup and restore than from a simple sweep? Does
a
>sweep reset the metadata change ids? That is, can you make 250 metadata
>changes, do a sweep and then do another 250? Apparently, 255 is the max
>changes before a backup and restore is required.

Yup. If you have a database that's still under development and you're
hitting the limit regularly, you have no option but gbak and restore to
reset them.
####

What does a "metadata change" constitute? Any type of change? Table
dropping, table adding, index creation/removal etc. etc. Or is is the number
of transactions that involve changes to the database?

This would be very helpful for us to know.

Regards
Chris