Re: How come SQL server does easy Hot backups?

Hang on a second -

If we are talking about SQL Server I presume we are talking about a Windows platform, not one of the 70+ platforms that Oracle runs on.

It is absolutely true that Oracle __suffers__ problems with hot backups on Windows platforms. One of the commonest problems is the:

    Don't touch this file, another process has it open.

The Oracle hot backup utilities simply call the appropriate published APIs for bypassing the normal locking procedures and from time to time they just don't seem to work.

Does the database server written by Microsoft have fewer problems when calling the Operating system written by Microsoft ? I wonder why.

Whilst we're on the subject - isn't it wonderful the way that NT on shutdown doesn't let an Oracle database shutdown properly, it just kicks it do death after a brief pause. Does it do the same with SQL server ? Few people notice this as an issue mind you, since Oracle is so good at recovering after an operating system has crashed on it.

--

Jonathan Lewis
Yet another Oracle-related web site: http://www.jlcomp.demon.co.uk

Alex Hudghton wrote in message <7rameu$gdq$1_at_taliesin.netcom.net.uk>...
>
>Joe F <Work_at_home.com> wrote in message
>news:qL4C3.1986$Oy6.64474_at_news2-hme0...
>> How come msSQL server has no problems with Hot backups, there is no need
>to
>> take a database down for a disk backup. And Oracle 7.3 has a major
problem
>> managing Hot backups?
>
>OK I'll bite - it doesn't
>
>Alex
>
>
Received on Fri Sep 10 1999 - 06:36:36 CDT