"IDES for index %d of table %d in dbid %d not in cache"?

[Mikhail T.]

When preparing a database for the "proper dump" (suitable for the potential
LOAD onto a server with different endianness), we do

"EXEC sp_dboption '%s', 'single user', 'TRUE'",
"use %s",
"EXEC sp_flushstats",
"checkpoint",
"use master",

The sp_flushstats (or maybe it is the checkpoint) sometimes produce A LOT of
messages like:

[...]
SERVER: IDES for index 2 of table 2136391649 in dbid 29 not in cache
[...]
SERVER: DBCC execution completed. If DBCC printed error messages, contact a
user with System Administrator (SA) role.

What are these? Should we worry about the dump after this? Are these "error
messages" or simply cryptic information of no value?

Thanks!

-mi

[A.M.]

Post by Mikhail T.
When preparing a database for the "proper dump" (suitable for the potential
LOAD onto a server with different endianness), we do
"EXEC sp_dboption '%s', 'single user', 'TRUE'",
"use %s",
"EXEC sp_flushstats",
"checkpoint",
"use master",
The sp_flushstats (or maybe it is the checkpoint) sometimes produce A LOT of

Its the call to sp_flushstats.

Post by Mikhail T.
[...]
SERVER: IDES for index 2 of table 2136391649 in dbid 29 not in cache
[...]
SERVER: DBCC execution completed. If DBCC printed error messages, contact a
user with System Administrator (SA) role.
What are these?

OUtput from a dbcc call. Look at the source to sp_flushstats
either in sybsystemprocs or in the installmaster script.

Post by Mikhail T.
Should we worry about the dump after this? Are these "error
messages" or simply cryptic information of no value?

More likely the latter although they may be usful in
the correct context.

-am © MMVI