Showing results for 
Search instead for 
Did you mean: 

Change path of files

Former Member
0 Kudos


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.


Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos


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