MultiCloud Marketplace


Database Manager for Microsoft SQL Server (v12.11.4-LTS)

Open in Dashboard

Published by RightScale on Nov 21, 2012Revision: 13


This ServerTemplate is on the LTS Lineage. For the latest Infinity version, see the Infinity Lineage
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. 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.

Related ServerTemplates:
Microsoft Active Directory
Microsoft IIS App Server

Release Notes:
Database Manager for MS SQL Server Release Notes

Application versions:

  • .Net 4.0
  • SQL Server 2008 (on 2008 image)
  • SQL Server 2008R2 (on 2008R2 image)

Supported compute clouds:

  • Amazon Web Services EC2
  • Citrix CloudStack (2.2)
  • Logicworks
  • Rackspace

Supported backup clouds:

  • Amazon Web Services S3
  • Rackspace CloudFiles (US)

Supported MultiCloud Images:

  • Windows 2008R2 - Amazon, CloudStack, Logicworks, Rackspace
  • Windows 2008 - Amazon


  • MultiCloudImage: RightImage_Windows_2008R2_SP1_x64_sqlsrv2k8r2_v5.8_XenServer-LTS [rev 1]

  • MultiCloudImage: RightImage_Windows_2008_SP2_x64_sqlsvr2k8_v5.8-LTS [rev 1]

  • MultiCloudImage: RightImage_Windows_2008R2_SP1_x64_sqlsvr2k8r2_v5.8-LTS [rev 1]

  • RightScript: DB SQLS Switch mirroring off (v12.11.0-LTS) [rev 1]

  • RightScript: DB SQLS Configure Database Backup Policy (v12.11.1-LTS) [rev 2]

  • RightScript: DB SQLS Configure TempDB (v12.11.0-LTS) [rev 1]

  • RightScript: DB SQLS Create login (v12.11.0-LTS) [rev 1]

  • RightScript: DB SQLS DISABLE SERVER - backup, detach and delete volumes (v12.11.1-LTS) [rev 2]

  • RightScript: DB SQLS Init mirror (v12.11.4-LTS) [rev 7]

  • RightScript: DB SQLS Init principal (v12.11.4-LTS) [rev 3]

  • RightScript: DB SQLS Install monitors (v12.11.1-LTS) [rev 2]

  • RightScript: DB SQLS Manual failover (v12.11.0-LTS) [rev 1]

  • RightScript: DB SQLS Promote to Principal (v12.11.0-LTS) [rev 1]

  • RightScript: DB SQLS Repair log files (v12.11.0-LTS) [rev 1]

  • RightScript: DB SQLS Restore all databases from S3 / Cloud Files (v12.11.2-LTS) [rev 5]

  • RightScript: DB SQLS Restore database from disk / S3 / Cloud Files (v12.11.2-LTS) [rev 4]

  • RightScript: DB SQLS Set Full Recovery Model (v12.11.0-LTS) [rev 1]

  • RightScript: DB SQLS Set default backup compression (v12.11.0-LTS) [rev 1]

  • RightScript: DB SQLS Set mixed authentication mode (v12.11.0-LTS) [rev 1]

  • RightScript: DB SQLS Setup volumes and services (v12.11.2-LTS) [rev 5]

  • RightScript: DB SQLS Start mirroring (v12.11.3-LTS) [rev 4]

  • RightScript: DB SQLS Backup database to disk / S3 / Cloud Files (v12.11.2-LTS) [rev 3]

  • RightScript: DB SQLS Update SQL Server 2008R2 Product Key (v12.11.0-LTS) [rev 1]

  • RightScript: DNS Register IP (v12.11.0-LTS) [rev 2]

  • RightScript: DB SQLS Attach database from disk / S3 / Cloud Files (v12.11.1-LTS) [rev 2]

  • RightScript: DB SQLS Backup all databases to S3 / Cloud Files (v12.11.1-LTS) [rev 2]

  • RightScript: DB SQLS Backup Data and Log volumes (v12.11.1-LTS) [rev 3]

  • RightScript: SYS Activate Windows with KMS server (v12.11.0-LTS) [rev 1]

  • RightScript: SYS Create Backup volume (v12.11.0-LTS) [rev 1]

  • RightScript: SYS Disable Windows Firewall (v12.11.0-LTS) [rev 1]

  • RightScript: SYS Enable Windows Firewall (v12.11.0-LTS) [rev 1]

  • RightScript: SYS Install 7-Zip (v12.11.0-LTS) [rev 1]

  • RightScript: SYS Install AWS SDK for .NET (v12.11.0-LTS) [rev 1]

  • RightScript: SYS Install All Windows Updates (v12.11.0-LTS) [rev 1]

  • RightScript: SYS Install Microsoft update by KB number (v12.11.0-LTS) [rev 2]

  • RightScript: SYS Install RightScale Powershell library (v12.11.4-LTS) [rev 7]

  • RightScript: SYS Install tools for Database Manager for Microsoft SQL Server (v12.11.0-LTS) [rev 1]

  • RightScript: SYS Monitoring install Windows (v12.11.0-LTS) [rev 1]

  • RightScript: SYS Set Windows Automatic Updates Policy (v12.11.0-LTS) [rev 1]

  • RightScript: SYS Set admin account (v12.11.0-LTS) [rev 1]

  • RightScript: SYS Timezone set Windows (v12.11.0-LTS) [rev 1]

  • RightScript: SYS Unmount removable and compact disk drives (v12.11.0-LTS) [rev 1]

  • See More


Revision 13 | Nov 21, 2012

Final commit for v12.11.4-LTS release

Revision 11 | Oct 23, 2012

Final commit for v12.11.3-LTS release

Revision 9 | Sep 05, 2012

Final commit for 12.11.2-LTS release

Revision 5 | Jul 21, 2012

v12.11.1-LTS final commit

Revision 2 | Jun 29, 2012

Final Commit for v12.11.0-LTS



2 Ratings

Supported Clouds


All Users

Sign-up for RightScale

Support Information