File Name extension letter increase each time we rebuild

[RiclWash]

Every time we rebuild our database, the file extension name increases by one letter. Can anyone tell us why this happens, how to prevent it and/or how to get it back to the original extension?

example: "dbspace.DB" has grown to "dbspace.DBRRRRRRRRERRR"

There is an R for each rebuild and the E is when we rebuilt with Encryption.

[johnsmirnios]

It is done so that the filename will be different from the one you are unloading from.

[RiclWash]

Right, but can we rename them to get rid of the extra?

[johnsmirnios]

Yes. Use ALTER DBSPACE RENAME: https://help.sap.com/docs/SAP_SQL_Anywhere/93079d4ba8e44920ae63ffb4def91f5b/8168f96e6ce21014a0a59fbe...

[RiclWash]

Thank You!

[former_SQLA_member1694955]

It seems like your database management system or the process you're using to rebuild your database is appending additional characters to the file extension every time you perform a rebuild. The behavior you've described is not typical for standard database systems, and it's possible that there might be some custom scripting or configuration causing this.

[VolkerBarth]

No, it's no custom scripting but the default behaviour when using the builtin DBUNLOAD tool with the -an or -ar options (and possibly others) to replace the existing database - it's done to prevent file name conflicts if the dbspace file for the new database is created in the same directory as the dbspace for the original database.