DB SQLS Backup Data and Log volumes (v13.3) by RightScale
Backs up data and logs volumes by creating a volume backup and using Volume Shadow Copy Service (VSS) to freeze disk activity on data files. Note that VSS does not guarantee consistency of log files. Alternatively, this script can create a differential o
DB SQLS Install monitors (v13.3) by RightScale
Installs Microsoft SQL Server specific monitoring.
Accesses SQL Server backup file from an Amazon S3 bucket or Rackspace Cloud Files container and restores the database from that backup.
Attaches SQL Server database file (.mdf) to SQL Server instance. Data file can be downloaded from Amazon S3/Rackspace Cloud Files or copied to SQL Server data directory from local disk (i.e., previously attached volume).
DB SQLS Set Full Recovery Model (v13.3) by RightScale
Sets full recovery model for all non-system databases.
DB SQLS Update SQL Server 2008R2 Product Key (v13.3) by RightScale
This script performs Microsoft SQL Server 2008R2 product key update. This script can be used to upgrade the edition of Microsoft SQL Server 2008R. This includes upgrading the evaluation edition to a production license or any other edition upgrades.
DB SQLS Generate and Save a Certificate (v13.3) by RightScale
Used to generate encoded data for credential (certificate and password encrypted private key).
Unique credential required for each mirroring partner in MS SQL Server mirroring session.