Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle8i vs. SQL Server 2000

Re: Oracle8i vs. SQL Server 2000

From: <mikel_at_usin.com>
Date: Wed, 23 Aug 2000 20:54:34 GMT
Message-ID: <8o1dlv$f5a$1@nnrp1.deja.com>

> This to my knowledge has not been addressed. Also you will want to
 consider
> that SQLServer has NEVER been 7 X 24 unless you forgo good backups.
 You
> cannot now nor have you been able to run a recoverable backup on this
 product
> without running DBCC in single user mode. This is a carryover from
 when
> Microsoft purchased SQLServer from Sybase.

A slight clarification on one point, you do not HAVE to run DBCC and you can do a hot backup at almost any time even if there are active user transactions going on at the time. SQL/Sybase servers do their backups very differently than Oracle. The DBCC is a consistancy check of the entire database that simply assures you that there were no database corruptions present at the time the backup was made. This is an insurance step. In Oracle, if you took a tablespace file off line, backed it up, and it had a logical corruption (i.e. a screwed up page chain, unreadable spot on disk, etc.), it's of little use. In SQL/Sybase, DBCC will detect and possibly correct any problem before you back up the data or loose any further data.

In article <399E08EE.E730BBCB_at_netzero.com>,   rmpowell_at_netzero.com wrote:
> Peter,
>
> You should advise your group that is contemplating such a major SNAFU
 that
> SQLServer at best is only scalable on the NT environment. It cannot
 take
> advantage of the scalabilty available to Oracle. Also there were
 major
> concerns over the last release's ability to support > 50 concurrent
 users.
> This to my knowledge has not been addressed. Also you will want to
 consider
> that SQLServer has NEVER been 7 X 24 unless you forgo good backups.
 You
> cannot now nor have you been able to run a recoverable backup on this
 product
> without running DBCC in single user mode. This is a carryover from
 when
> Microsoft purchased SQLServer from Sybase.
>
> For your sake make them aware of what this option limits the company
 to. If
> I were you I would refuse to support it and look for another job. If
 you are
> an Oracle DBA that should not be a problem.
>
> Rick Powell
> yensid_at_watsoncable.com
> OCP DBA
>
> Peter Livingwater wrote:
>
> > I saw presentation slide, but I can not locate in the web.
> >
> > Ernest D. Stalnaker <ernest_at_purdue.edu> wrote in message
> > news:8i64ls$e3m$1_at_mozo.cc.purdue.edu...
> > > Does anyone know of any whitepapers or other documents that
 compare the
> > > features of Oracle8i vs. Microsoft SQL Server 2000? I know that
 SQL
 Server
> > > 2000 is still in beta, but it is supposed to be released sometime
 this
> > > summer. We are primarily an Oracle shop, but one of our
 departments is
> > > considering switching to SQL Server, so I want to be able to give
 them
 some
> > > accurate information on the pros & cons of making the switch.
> > >
> > > Thanks in advance to anyone who can help me!
> > >
> > > Ernest D. Stalnaker
> > > Database Administrator
> > > Management Information
> > > Purdue University
> > > West Lafayette, Indiana
> > > E-Mail: ernest_at_purdue.edu
> > >
> > >
> > >
>
>

--
Michael Lackey  mikel_at_usin.com


Sent via Deja.com http://www.deja.com/
Before you buy.
Received on Wed Aug 23 2000 - 15:54:34 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US