MSSQL Cloud Sites Databases
Cloud Sites provides robust support for Microsoft SQL Server (MSSQL) to power your Windows applications. This hub covers the essential tasks for managing your SQL environment. You will learn how to protect your data with manual and cron-based backups, restore databases using myLittleAdmin, and connect securely via SQL Server Management Studio (SSMS). We also guide you through fixing common errors and remapping user permissions.
MSSQL Databases in Cloud Sites Articles
Use these resources to back up your data, manage SQL users, and troubleshoot common MSSQL issues.
Backup a Cloud Sites MSSQL Database Using a cron
Read more: Backup a Cloud Sites MSSQL Database Using a cronFollow these steps to create a cron to back up your MSSQL databases.
Backup Your MSSQL Database in Cloud Sites
Read more: Backup Your MSSQL Database in Cloud SitesRegularly backing up your database is crucial for site maintenance on Cloud Sites. To manually backup your MSSQL database, access myLittleAdmin from the Cloud Sites control panel.
Invalid MSSQL Cast Exception on Cloud Sites
Read more: Invalid MSSQL Cast Exception on Cloud SitesCloud Sites Windows clusters use specific data types that may introduce errors for some custom applications. The following is a work around for this known issue.
Remap Cloud Sites MSSQL Users
Read more: Remap Cloud Sites MSSQL UsersRemap the server-level logins on Microsoft SQL Server database users on Cloud Sites.
Restore a Cloud Sites MSSQL Database
Read more: Restore a Cloud Sites MSSQL DatabaseRestore your Cloud Sites MSSQL Database from a backup through myLittleAdmin.
Windows SQL Server Management Studio for Cloud Sites
Read more: Windows SQL Server Management Studio for Cloud SitesSecurely access your MSSQL database for Cloud Sites using Microsoft SQL Server Management Studio.