MultiCloud Marketplace

RightScale

Database Manager for Microsoft SQL Server (v13.5.1)

Open in Dashboard

Published by RightScale on Oct 23, 2012Revision: 55 This component has been deprecated by the publisher.

Description

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

Documentation:
Database Manager for MS SQL Server Release Notes
Tutorial


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

Contents

  • MultiCloudImage: SoftLayerImage_Storage_Windows_2008R2_SP1_x64_sqlsvr2k8r2_v5.8 [rev 2]

  • MultiCloudImage: RightImage_Windows_2008_SP2_x64_sqlsvr2k8_v5.8 [rev 9]

  • MultiCloudImage: RightImage_Windows_2008R2_SP1_x64_sqlsvr2k8r2_v5.8 [rev 18]

  • MultiCloudImage: RightImage_Windows_2008R2_SP1_x64_sqlsvr2012_v5.8 [rev 11]

  • MultiCloudImage: RightImage_Windows_2008R2_SP1_x64_sqlsrv2k8r2_v5.8_XenServer [rev 13]

  • MultiCloudImage: RightImage_Windows_2008R2_SP1_x64_sqlsrv2k8r2_v5.8_VMware [rev 8]

  • RightScript: DNS Register IP (v13.0) [rev 7]

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

  • RightScript: DB SQLS Init mirror (v13.1.1) [rev 20]

  • RightScript: DB SQLS Init principal (v13.1.1) [rev 21]

  • RightScript: DB SQLS Install monitors (v13.1.1) [rev 11]

  • RightScript: DB SQLS Manual failover (v13.1) [rev 11]

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

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

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

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

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

  • RightScript: DB SQLS Start mirroring (v13.1.1) [rev 17]

  • 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.1) [rev 12]

  • RightScript: DB SQLS Configure TempDB (v13.1) [rev 7]

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

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

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

  • RightScript: SYS Activate Windows with KMS server [rev 4]

  • RightScript: SYS Create Backup volume (v13.1) [rev 10]

  • 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.0) [rev 6]

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

  • RightScript: SYS Install RightScale Powershell library (v13.1.1) [rev 46]

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

  • RightScript: SYS Monitoring install Windows (v13.0) [rev 15]

  • RightScript: SYS Reconfigure Azure temp volume and pagefile (v13.0) [rev 3]

  • RightScript: SYS Set Windows Automatic Updates Policy [rev 2]

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

  • See More

Revisions

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

Discussion

5a548335d3f2cb04c03633b14849bd18Shinsuke Kanno on Nov 18, 2012 | Re: v55

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

Info

No Ratings

Supported Clouds

Pricing

All Users

Sign-up for RightScale

Support Information

http://support.rightscale.com/ServerTemplates