dbR files after unload/reload

I'm converting ASA9 database to SA11.

This database have 4 dbspaces (main +3), after all process, extra dbspace files, have dbR extension. Is it safe to just rename to .db ?

asked 28 Sep '11, 08:34

Zote
1.7k●36●40●51
accept rate: 43%

edited 28 Sep '11, 08:35

flat view

One Answer:

active answers oldest answers newest answers popular answers

Yes, it is safe to rename the dbspaces to have any name you would like but when you do so you need to also execute an "ALTER DBSPACE RENAME ..." statement for each dbspace to tell the database server the new name of each file.

permanent link

answered 28 Sep '11, 08:55

Mark Culp
24.8k●9●139●295
accept rate: 41%

Thank you Mark. And can you tell me why file name ends with R?

(28 Sep '11, 14:45) Zote

Replies hidden

The dbspaces get assigned an extension of "dbR" so as to not conflict with the original file name's extension (typically "dbs") - in case the new file is in the same directory as the original file - and to make it obvious which files are the new "rebuilt" dbspaces. This is explained in the docs: http://dcx.sybase.com/1201/en/dbadmin/dbunload.html

(28 Sep '11, 14:55) Mark Culp

flat view

Your answer

toggle preview

community wiki:

Follow this question

By Email:

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

By RSS:

Answers

Answers and Comments

Markdown Basics

*italic* or _italic_
**bold** or __bold__
link:[text](http://url.com/ "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

learn more about Markdown

Question tags:

asa-9 ×107
migration ×52
sa-11.0.1 ×23
dbspace ×22
file ×22

question asked: 28 Sep '11, 08:34

question was seen: 3,639 times

last updated: 28 Sep '11, 14:55

SAP SQL Anywhere

dbR files after unload/reload

Follow this question

Related questions