Re: Sybase vs Oracle - which is better?

Yassir Khogaly wrote:
>
> So can you backup a sybase database while the database is shut.!

YES, sort of, you actually backup the devices which hold the database. This does require some planning since Sybase allows multiple databases to reside on a single device. It is not completely straight forward or recommended ( by me :).

> Does Sybase support UNIX Filesystem fully as it dows for RAWDevices ...?

        Sybase supports Asynch I/O for both raw partions and file system devices. However, file system devices do use buffered OS cache to write to disk. So, I guess you could look at it as a choice.

> Does Sybase Run Under NT.!?

Yes, Sybase runs very well on NT. And, it supports raw partitions and file system devices. On NT, file system devices are opened with a write thru flag which instructs the OS to write directly to disk. So, you avoid the buffered latancy of the UNIX write to file system devices.

Cheers,
Robert Received on Thu Nov 19 1998 - 00:00:00 CST