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 |
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 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. |
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...