MultiCloud Marketplace


Database Manager for Microsoft SQL Server (13.5.1-LTS)

Open in Dashboard

Published by RightScale on Sep 11, 2013Revision: 5


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

Related ServerTemplates:
Microsoft SQL Server Witness
Microsoft Active Directory
Microsoft IIS App Server

Database Manager for MS SQL Server Release Notes

Application versions: * .Net 3.5SP1 * .Net 4.0 * .Net 4.5 * PowerShell 2.0 * PowerShell 3.0 * SQL Server 2008R2 (on Windows 2008R2 image) * SQL Server 2008R2 Enterprise (Windows 2008R2 image - Windows Azure only) * SQL Server 2012 (on Windows 2008R2 & Windows 2012 images - n/a for SoftLayer) * SQL Server 2012 Enterprise (Windows 2008R2 & Windows 2012 images - 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, Rackspace Open Cloud, Rackspace Private, Windows Azure * Windows 2008R2/SQL 2008R2 - Amazon, CloudStack, Rackspace Open Cloud, Rackspace Private, SoftLayer


  • MultiCloudImage: SoftLayerImage_Storage_Windows_2008R2_SP1_x64_sqlsvr2k8r2_v13.5.0-LTS [rev 2]

  • MultiCloudImage: RightImage_Windows_2012_x64_sqlsvr2012ent_v13.5.0-LTS [rev 2]

  • MultiCloudImage: RightImage_Windows_2012_x64_sqlsvr2012_v13.5.0_XenServer-LTS [rev 2]

  • MultiCloudImage: RightImage_Windows_2012_x64_sqlsvr2012_v13.5.0_VMware-LTS [rev 2]

  • MultiCloudImage: RightImage_Windows_2012_x64_sqlsvr2012_v13.5.0_KVM-LTS [rev 2]

  • MultiCloudImage: RightImage_Windows_2012_x64_sqlsvr2012_v13.5.0-LTS [rev 2]

  • MultiCloudImage: RightImage_Windows_2008R2_SP1_x64_sqlsvr2k8r2ent_v13.5.0-LTS [rev 2]

  • MultiCloudImage: RightImage_Windows_2008R2_SP1_x64_sqlsvr2k8r2_v13.5.0_XenServer-LTS [rev 2]

  • MultiCloudImage: RightImage_Windows_2008R2_SP1_x64_sqlsvr2k8r2_v13.5.0_VMware-LTS [rev 2]

  • MultiCloudImage: RightImage_Windows_2008R2_SP1_x64_sqlsvr2k8r2_v13.5.0-LTS [rev 2]

  • MultiCloudImage: RightImage_Windows_2008R2_SP1_x64_sqlsvr2012ent_v13.5.0-LTS [rev 2]

  • MultiCloudImage: RightImage_Windows_2008R2_SP1_x64_sqlsvr2012_v13.5.0_XenServer-LTS [rev 2]

  • MultiCloudImage: RightImage_Windows_2008R2_SP1_x64_sqlsvr2012_v13.5.0-LTS [rev 2]

  • MultiCloudImage: RightImage_Windows_2008R2_SP1_x64_sqlsvr2012_v13.5.0_VMware-LTS [rev 2]

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

  • RightScript: DB SQLS Recreate master key (v13.5.0-LTS) [rev 1]

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

  • RightScript: DB SQLS Restore all databases from Remote Storage (v13.5.0-LTS) [rev 1]

  • RightScript: DB SQLS Restore database from local disk / Remote Storage (v13.5.0-LTS) [rev 1]

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

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

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

  • RightScript: DB SQLS Setup volumes and services (v13.5.0-LTS) [rev 1]

  • RightScript: DB SQLS Start mirroring (v13.5.0-LTS) [rev 1]

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

  • RightScript: DB SQLS Switch witness off (v13.5.0-LTS) [rev 1]

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

  • RightScript: DNS Register IP (v13.5.0-LTS) [rev 1]

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

  • RightScript: DB SQLS Install monitors (v13.5.0-LTS) [rev 1]

  • RightScript: DB SQLS Init witness (v13.5.0-LTS) [rev 1]

  • RightScript: DB SQLS Init principal (v13.5.0-LTS) [rev 2]

  • RightScript: DB SQLS Init mirror (v13.5.0-LTS) [rev 1]

  • RightScript: DB SQLS Generate and Save a Certificate (v13.5.0-LTS) [rev 1]

  • RightScript: DB SQLS DISABLE SERVER - backup, detach and delete volumes (v13.5.0-LTS) [rev 1]

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

  • RightScript: DB SQLS Configure scheduled tasks (v13.5.0-LTS) [rev 1]

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

  • RightScript: DB SQLS Backup database to local disk / Remote Storage (v13.5.0-LTS) [rev 1]

  • RightScript: DB SQLS Backup all databases to Remote Storage (v13.5.0-LTS) [rev 1]

  • RightScript: DB SQLS Backup Data and Log volumes (v13.5.0-LTS) [rev 1]

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

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

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

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

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

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

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

  • RightScript: SYS Install Microsoft update by KB number (v13.5.0-LTS) [rev 1]

  • RightScript: SYS Install RightScale Powershell library (v13.5.0-LTS) [rev 2]

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

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

  • RightScript: SYS Reconfigure Azure temp volume and pagefile (v13.5.0-LTS) [rev 1]

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

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

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

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

  • RightScript: DB SQLS Attach database from local disk / Remote Storage (v13.5.0-LTS) [rev 1]

  • See More


Revision 5 | Sep 11, 2013

Final commit for v13.5.1-LTS release

Revision 2 | Aug 29, 2013

Final commit for v13.5.0-LTS release



No Ratings

Supported Clouds


All Users

Sign-up for RightScale

Support Information