Hello,

I'm a SQL Anywhere newbie. I've created a SQL Anywhere database using 3rd party software (SAP Business Objects). However, the database file is now located some place I don't want it.

Can someone please tell me what steps I need to perform to move the .db and .log file from, let's say 'C:Mydir' to 'D:Mydir'?

Kind regards

asked 29 May '12, 07:31

Galactico076's gravatar image

Galactico076
76338
accept rate: 0%

Just a note: "D:" should be a local drive (which it is, I suppose), not a network share - running SQL Anywhere databases on a network share is not recommended...

(29 May '12, 07:59) Volker Barth

Simply make sure the database isn't running and then just move the files. You may also want to check that the transaction log file location has not be "hard-coded" into the database file. run dblog mydatabase.db and it will tell you what it's using for the transaction log file. If it's just the filename (eg. "mydatabase.db" is using log file "mydatabase.log") then you're good to go. If it's a full path, you'll need to use the dblog -t switch to change it.

That's all that needs to be done to move the database files themselves. You'll then have to tell the database server where the file is before it can start it.

permanent link

answered 29 May '12, 07:38

Graeme%20Perrow's gravatar image

Graeme Perrow
8.5k371109
accept rate: 52%

Your answer
toggle preview

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

Question tags:

×20

question asked: 29 May '12, 07:31

question was seen: 1,782 times

last updated: 29 May '12, 07:59