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.
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It only takes a minute to sign up.Sign up to join this community
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 restart
disk mirrorcommand for each device you want to move; once the initial copy has completed ...
disk unmirrorcommand to make the mirror devices the new primary devices
sp_configure 'disable disk mirror',1; there's a small performance hit for leaving this enabled when not needed; again, requires a dataserver restart
NOTE: 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
There are some unsupported methods that consist of updating the
master..sysdevices table and physically copying/moving the OS-level database files but ...