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@xxxxxxxxx> 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@xxxxxxxxxxxxxxxxxxxxx>
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@xxxxxxxxx>
*Datum *Samstag, 09. Nov. 2019, 4:46 PM
*An: *wbfergus@xxxxxxxxx <wbfergus@xxxxxxxxx>
*Cc: *Oracle-L Freelists <oracle-l@xxxxxxxxxxxxx>
*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
