fredag 28 augusti 2009

Removing devices in Sybase ASE

So I'm in the processes of scripting and setting up warm standby replication server for the first time and are messing around with databases in Sybase ASE 12.5.

So I drop my database and then use sp_dropdevice [device name]. Now what happens? I have dropped the device, but it's still in the file system. Not even a parameter available in sp_dropdevice to remove the device file. Not a big problem, just thinking why only do things half way and not give the user a option to remove the file as well?

Of course there are numerous solutions to do this I just added:
!!rm /name/of/device in the script.

It just feels kind of clunky. :-(