Database Manager for Microsoft SQL Server (v13.3)

Published by RightScale on Mar 06, 2013Revision: 75

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 stand-alone 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 image - Amazon, Rackspace Open Cloud, and Windows Azure only)

Supported compute clouds:

Amazon Web Services EC2
Citrix CloudStack (3.0.6)(XenServer, VMware)
Rackspace Open Cloud (US and UK)
SoftLayer
Windows Azure

Supported Storage Services:

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

Supported MultiCloud Images:

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

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