DB SQLS Configure TempDB (v13.3) by RightScale
Configures tempdb according to Microsoft recommendations (http://msdn.microsoft.com/en-us/library/ms175527.aspx):
- Sets recovery model to simple.
- Creates as many data files (of the same size) as
DB SQLS Promote to Principal (v13.3) by RightScale
Performs forced (disaster-recovery) failover from mirror instance, with possible data loss.
DB SQLS Switch mirroring off (v13.3) by RightScale
Switches mirroring off for all non-system databases on the server.
DB SQLS Set mixed authentication mode (v13.3) by RightScale
This script sets authentication mode for SQL Server to Mixed (SQL Server and Windows authentication mode) and restarts MS SQL Server.
DB SQLS Backup all databases to Remote Storage (v13.3) by RightScale
Creates differential or full backup of all user and system databases and uploads to remote storage (Amazon S3 or Cloud Files). Implements simple cleanup policy to keep specified number of previously created backups.
DB SQLS Setup volumes and services (v13.3) by RightScale
This script creates new data and log volumes or restores the volumes from previous backup. Specify the type of backup to restore from using the BACKUP_METHOD input. To force new volume creation instead of restoring, use the OPT_FORCE_CREATE_VOLUMES inp
DB SQLS Start mirroring (v13.3) by RightScale
This script starts a mirroring session by invoking the "DB SQLS Init principal" RightScript on principal server or "DB SQLS Init mirror" RightScript on mirror server (depending on value of the SERVER_MODE input). Does nothing on a standalone server. Design