Change path of files

[Former Member]

Hello,

How can I change the files of Sybase Ase from one old path to a new path? I need to move the log (saplog_1)  and saptemp.

Thanks.

[Former Member]

Ruben,

The ASE table master..sysdevices list the path of the ASE database devices.

You would need to make these changes with the server in single user mode to be safe...

(which is really dangerous)

select * from master..sysdevices

I have seen methods where mirrored devices were created then the primary device was removed...

This is a task that should only be done in a "test/play" area until you totally understand the mechanics of the steps involved.

First, become familiar with all of the system tables of the master database.

Systems Table Diagram

HTH

Cory