Sql Server 2012 Enterprise __top__ -

-- Get max partition number SELECT @MaxPartition = MAX(partition_number) FROM sys.partitions WHERE object_id = @ObjectID;

This replaced older mirroring technologies by allowing users to fail over multiple databases as a single group. Secondary copies remain readable and can be used for backups, ensuring disaster recovery environments do not sit idle. Standard vs. Enterprise Comparison sql server 2012 enterprise