MultiCloud Marketplace


Database Manager for Microsoft SQL Server (v14.0.1)

Open in Dashboard

Published by RightScale on Mar 06, 2013Revision: 75 This component has been superseded. Get the current version here


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

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) * 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) * Windows Azure

Supported private compute clouds: * Citrix CloudStack (4.2.1)(XenServer and VMware) * OpenStack Havana (KVM) * Rackspace Private Cloud (KVM)

Supported Storage Services: * Amazon Simple Storage Service (S3) * OpenStack Swift (Havana) * Rackspace Cloud Files (US, UK) * Rackspace Private (Swift)(Havana) * Windows Azure Blob Storage

Supported MultiCloud Images: * Windows 2012/SQL 2012 - Amazon, CloudStack, OpenStack, Rackspace Open Cloud, Rackspace Private, Windows Azure * 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, Windows Azure * Windows 2012/SQL 2012ent - Windows Azure * Windows 2008R2/SQL 2012ent - Windows Azure * Windows 2008R2/SQL 2008R2ent - Windows Azure


  • 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]

  • See More


Revision 185 | Jul 10, 2015

Final commit for Database Manager for Microsoft SQL Server (v14.0.1)

Revision 179 | May 27, 2014

Final commit for v14.0.1 - bug fix

Revision 113 | Sep 11, 2013

Final commit for release v13.5.1

Revision 110 | Aug 30, 2013

Final commit for release v13.5

Revision 93 | Jul 01, 2013

Final commit for v13.4 release

Revision 75 | Mar 06, 2013

Final commit for 13.3 release

Revision 64 | Jan 10, 2013

Republish of Release v13.2

Revision 39 | Jun 29, 2012

Final Commit for 12.11

Revision 27 | Apr 19, 2012

Minor bug fixes to rev 26: Fixed forced SQL fail-over. Changed default instance sizes for SQL Server RightImages on AWS to m1.large

Revision 20 | Feb 10, 2012

Sprint 31 release


C331422f1c5594ad4c2ef707562d3f4dShinsuke Kanno on Nov 18, 2012 | Re: v55

Is IDCFrontier supported this Servertemplate ? There is no name "Supported compute clouds" .


No Ratings

Supported Clouds


All Users

Sign-up for RightScale

Support Information