| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Please advice sql server vs. Oracle
Comments below
> What is probably missing as a bit of extra information
> is that the restore involves the ENTIRE database, OFFLINE.
> There is no such thing as partial restores, partial backups,
> incremental backups or partial recovery with SS2K. It's all
> or nothing. And when all is being restored, you're out for
> the duration.
It is worth comparing apples with apples though, in particular an mssql database is not equivalent to an oracle database.
As far as partial restores and partial backups go SS2K most definitely does support both differential backups and file level backups - it doesn't have the nice block level backups of rman. Obviously if you chose not to use multiple datafiles and filegroups then you can't use this feature, but the same would be true in Oracle if you put everything in one tablespace with one datafile. I believe that this is new with ss2k - i.e. ss7 doesn't allow this.
The above is all covered in BOL under 'handling large mission-critical environments'.
You'll see that I've also had a discussion with Dan Morgan on usenet about mssql and it does sound like I'm turning into an ms apologist, I'm not, honest guv. On the other hand I'm not an Oracle apologist either - if it does the job it does the job, and don't let misconceptions and incorrect facts get in the way - I see far too many folk suggesting that only Oracle can handle enterprise computing needs and it just aint so.
Niall Litchfield
Oracle DBA
Audit Commission
+44 117 975 7805
-- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------Received on Wed Mar 31 2004 - 06:12:33 CST
 |
 |