Database Manager for Microsoft SQL Server (v13.4)

Published by RightScale on Dec 17, 2012Revision: 61 This component has been deprecated by the publisher.

Description

This ServerTemplate is on the Infinity Lineage. For the latest LTS version, see the 12-LTS Release
For a description of the Infinity and LTS lineages, see ServerTemplate Release Methodology

This ServerTemplate configures a Microsoft SQL Server standalone database server or pair of servers in a high-availability (HA) configuration (synchronous mirroring). The template supports graceful (no data loss) and forceful (possible data loss) manual failover, with the latter to be used for disaster-recovery situations. This can also be used with our SQL Server Witness template to provide automatic failover. Also included are built-in monitoring and alerts on CPU, memory, and disk.

Key Features:

MS Best Practices for disk and database configuration.
Cloud-agnostic data storage on dynamic volumes or equivalent.
Striped data and log volumes (on supported clouds).
Automatically scheduled backups with data consistency.
Backup and restore to/from remote storage to enable data migration between clouds.

Release Notes:
Database Manager for MS SQL Server Release Notes

Application versions:

.Net 3.5SP1
.Net 4.0
.Net 4.5
SQL Server 2008R2 (on Windows 2008R2 image - n/a for Windows Azure)
SQL Server 2012 (on Windows 2008R2 & Windows 2012 images - n/a for Softlayer)
SQL Server 2012 Enterprise (Windows 2008R2 image - Windows Azure only)

Supported public compute clouds:

Amazon Web Services EC2
Rackspace Open Cloud (US, UK)
SoftLayer
Windows Azure

Supported private compute clouds:

Citrix CloudStack (3.0.6)(XenServer and VMware)
OpenStack Folsom (KVM)
Rackspace Private Cloud (KVM)

Supported Storage Services:

Amazon Simple Storage Service (S3)
OpenStack Swift (Folsom)
Rackspace Cloud Files (US, UK)
Rackspace Private (Swift)(Folsom)
SoftLayer Object Storage
Windows Azure Blob Storage

Supported MultiCloud Images:

Windows 2012/SQL 2012 - Amazon, CloudStack, OpenStack, Rackspace Open Cloud, Rackspace Private
Windows 2008R2/SQL 2012 - Amazon, CloudStack, OpenStack, Rackspace Open Cloud, Rackspace Private, Windows Azure
Windows 2008R2/SQL 2008R2 - Amazon, CloudStack, OpenStack, Rackspace Open Cloud, Rackspace Private, SoftLayer

MultiCloudImage: SoftLayerImage_Storage_Windows_2008R2_SP1_x64_sqlsvr2k8r2_v5.8 [rev 3]
MultiCloudImage: RightImage_Windows_2008_SP2_x64_sqlsvr2k8_v5.8 [rev 11]
MultiCloudImage: RightImage_Windows_2008R2_SP1_x64_sqlsvr2k8r2_v5.8 [rev 21]
MultiCloudImage: RightImage_Windows_2008R2_SP1_x64_sqlsvr2012_v5.8 [rev 15]
MultiCloudImage: RightImage_Windows_2008R2_SP1_x64_sqlsrv2k8r2_v5.8_XenServer [rev 14]
MultiCloudImage: RightImage_Windows_2008R2_SP1_x64_sqlsrv2k8r2_v5.8_VMware [rev 9]
RightScript: DNS Register IP (v13.0) [rev 7]
RightScript: DB SQLS DISABLE SERVER - backup, detach and delete volumes (v13.1) [rev 25]
RightScript: DB SQLS Init mirror (v13.1.1) [rev 22]
RightScript: DB SQLS Init principal (v13.1.1) [rev 24]
RightScript: DB SQLS Install monitors (v13.2) [rev 12]
RightScript: DB SQLS Manual failover (v13.2) [rev 12]
RightScript: DB SQLS Promote to Principal (v13.2) [rev 14]
RightScript: DB SQLS Repair log files (v13.1) [rev 4]
RightScript: DB SQLS Restore all databases from Remote Storage (v13.1) [rev 19]
RightScript: DB SQLS Restore database from local disk / Remote Storage (v13.1) [rev 23]
RightScript: DB SQLS Set Full Recovery Model (v13.1) [rev 3]
RightScript: DB SQLS Set default backup compression (v13.1) [rev 4]
RightScript: DB SQLS Set mixed authentication mode (v13.1) [rev 6]
RightScript: DB SQLS Setup volumes and services (v13.1) [rev 33]
RightScript: DB SQLS Start mirroring (v13.2) [rev 22]
RightScript: DB SQLS Switch mirroring off (v13.1.1) [rev 8]
RightScript: DB SQLS Update SQL Server 2008R2 Product Key [rev 9]
RightScript: DB SQLS Create login (v13.1) [rev 14]
RightScript: DB SQLS Configure scheduled tasks (v13.2) [rev 13]
RightScript: DB SQLS Configure TempDB (v13.1) [rev 7]
RightScript: DB SQLS Backup database to local disk / Remote Storage (v13.1) [rev 22]
RightScript: DB SQLS Backup all databases to Remote Storage (v13.1) [rev 18]
RightScript: DB SQLS Backup Data and Log volumes (v13.1) [rev 24]
RightScript: SYS Activate Windows with KMS server [rev 4]
RightScript: SYS Create Backup volume (v13.1) [rev 11]
RightScript: SYS Disable Windows Firewall [rev 1]
RightScript: SYS Enable Windows Firewall [rev 1]
RightScript: SYS Install 7-Zip (v13.1) [rev 8]
RightScript: SYS Install AWS SDK for .NET (v13.1) [rev 7]
RightScript: SYS Install All Windows Updates (v13.1) [rev 7]
RightScript: SYS Install Microsoft update by KB number (v13.1) [rev 8]
RightScript: SYS Install RightScale Powershell library (v13.2) [rev 57]
RightScript: SYS Install tools for Database Manager for Microsoft SQL Server (v13.1) [rev 8]
RightScript: SYS Monitoring install Windows (v13.1) [rev 16]
RightScript: SYS Reconfigure Azure temp volume and pagefile (v13.0) [rev 3]
RightScript: SYS Set Windows Automatic Updates Policy (v13.1) [rev 3]
RightScript: SYS Set admin account - 12H1 [rev 17]
RightScript: SYS Timezone set [rev 9]
RightScript: SYS Unmount removable and compact disk drives (v13.1) [rev 5]
RightScript: DB SQLS Attach database from local disk / Remote Storage (v13.1) [rev 18]