A SQL Server Device CAL is required in order for a device (for example, a PC, workstation, terminal, PDA, mobile phone, and so on) to access or use the services or functionality of Microsoft SQL Server. The Server plus device CAL model will likely be the more cost-effective choice if there are multiple users per device (for example, in a call center). Please see multiplexing section to ensure every device is licensed properly. Exceptions include communication exclusively between SQL Servers and manual data transfer between employees.
Logged operations are replicated. These include, but are not limited to: DDL DML Create/alter table space Create/alter storage group Create/alter buffer pool XML data. Logged LOBs Not logged operations are not replicated. These include, but are not limited to: Database configuration parameters (this allows primary and standby databases to be configured differently). "Not logged initially" tables Not logged LOBs UDF (User Defined Function) libraries. UDF DDL is replicated. But the libraries used by UDF (such as C or Java libraries) are not replicated, because they are not stored in the database. Users must manually copy the libraries to the standby. Note: You can use database configuration parameter BLOCKNONLOGGED to block not logged operations on the primary.
Comments