Re: oracle v SS

A second question related to SQL server backups, please feel free to respond privately if needed: We will be having a database that is 20TB in size, a reporting/DW type DB with nightly loads. What are the commonly available backup strategies - On the Oracle side, we used to use SRDF with very little effect on the primary DB to backup huge DBs. There is also Dataguard to offsite the backups.

In one scenario, if we do not have the option of having a remote replicated site and we have to do the backup from the PDC (primary data center), what tools do we have for a SQL server DB of that size.

Is it possible to backup the 'partitions' only in the SQL server - this might make life lot easier to capture modified partitions only in the backups

On Mon, Nov 11, 2019 at 1:24 PM Orlando L <oralrnr_at_gmail.com> wrote:

>
> "Allows customers to install and run passive SQL Server instances in a
> separate OSE or server on-premises for disaster recovery"
>
> Does this mean the passive SQL server can be configured in a
> geographically remote site?
>
>
> On Mon, Nov 11, 2019 at 10:39 AM Rich J <rjoralist3_at_society.servebeer.com>
> wrote:
>
>> I didn't see this recent MS announcement of free "passive" licensing for
>> HA/DR in this thread:
>>
>>
>> https://cloudblogs.microsoft.com/sqlserver/2019/10/30/new-high-availability-and-disaster-recovery-benefits-for-sql-server/
>>
>> That seems...huge. Oracle has had some great announcements recently,
>> like with the PDB extension and Free Autonomous offering, but nothing to
>> this scale.
>>
>> Rich
>>
>> *Von: *Andre Maasikas <amaasikas_at_gmail.com>
>> *Datum *Samstag, 09. Nov. 2019, 4:46 PM
>> *An: *wbfergus_at_gmail.com <wbfergus_at_gmail.com>
>> *Cc: *Oracle-L Freelists <oracle-l_at_freelists.org>
>> *Betreff: *Re: oracle v SS
>>
>> Certainly not free, same with plsql mentioned earlier, all these use the
>> "licensed" cpu power which costs you about 100K €/$ per processor
>> definition (counting common enterprise options) initial license and 1/4 of
>> that each year thereafter.
>> Andre
>>
>>
>>
>>

--
http://www.freelists.org/webpage/oracle-l