I am trying to move sybase user database from one drive to another drive, can you please help me with procedure.
My database : Sybase ASE 16 OS windows.
The officially supported method would be to use ASE's disk mirroring capabilities to move all devices.
sp_configure 'disable disk mirror',0
); requires a dataserver restartdisk mirror
command for each device you want to move; once the initial copy has completed ...disk unmirror
command to make the mirror devices the new primary devicessp_configure 'disable disk mirror',1
; there's a small performance hit for leaving this enabled when not needed; again, requires a dataserver restartNOTE: If you move the master
device, you'll need to update your startup script (and/or Windows service) to reference the new path for the master
device.
There are some unsupported methods that consist of updating the master..sysdevices
table and physically copying/moving the OS-level database files but ...
Sybase move database files
yields a number of results, the first several of which are from SyBooks Online. Have you looked at these, and had a problem finding what you need there?