Please be aware that the SAP SQL Anywhere Forum will be shut down on August 29th, 2024 when all it's content will be migrated to the SAP Community.

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.

asked 27 Jul '23, 14:38

ricwash's gravatar image

accept rate: 0%

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

permanent link

answered 27 Jul '23, 14:48

John%20Smirnios's gravatar image

John Smirnios
accept rate: 37%

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

(27 Jul '23, 14:50) ricwash
Replies hidden

Thank You!

(03 Aug '23, 07:56) ricwash

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.

permanent link

answered 14 Aug '23, 09:32

Mobodon's gravatar image

accept rate: 0%


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.

(14 Aug '23, 10:06) Volker Barth
Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text]( "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:


question asked: 27 Jul '23, 14:38

question was seen: 400 times

last updated: 14 Aug '23, 10:06