Database administration best practices for Cloud SQL for SQL Server. Read this blog.

Jump to

Cloud SQL for SQL Server

Fully managed relational database service for Microsoft SQL Server. With Cloud SQL for SQL Server, you can now spend less time on your SQL Server database operations, and more time on your applications.

  • action/check_circle_24px Created with Sketch.

    Offers full compatibility for your applications on SQL Server production editions 2019 and 2017

  • action/check_circle_24px Created with Sketch.

    Automates database management tasks like provisioning, patching, high availability, and backups

  • action/check_circle_24px Created with Sketch.

    Ensures business continuity with reliable services backed by a world-class 24/7 SRE team

  • action/check_circle_24px Created with Sketch.

    Integrates with services like Google Kubernetes Engine (GKE), and Cloud Functions

  • action/check_circle_24px Created with Sketch.

    Offers compatibility with tools such as SQL Server Management Studio and SQL Server Data Tools

Key features

Key features of Cloud SQL for SQL Server

Compatible

Continue using the same tools and skills you rely upon today, such as PowerShell, SQL Server Management Studio (SSMS), and sqlcmd which can be accessed through gcloud CLI. We offer database compatibility extending back to SQL Server 2005, including support and access to SQL agent jobs you rely upon today.

Fully managed

Cloud SQL automatically ensures your SQL Server databases are reliable, secure, and scalable so that your business continues to run without disruption. Automate all your backups, failover, replication, software patching, and capacity increases—while ensuring more than 99.95% availability, anywhere in the world.

Secure SQL Server databases in the cloud

Your data is secured with automatic encryption at rest and in transit, with integrated support for customer managed encryption keys. Virtual Private Cloud (VPC) and user-controlled network access with firewall protection ensure access from trusted parties at all times. Compliant with SSAE 16, ISO 27001, PCI DSS, and HIPAA.

Integrated

Access Cloud SQL from virtually any application. Easily connect from Google Compute EngineGoogle Kubernetes Engine, and your workstation. Visualize your data with Looker to open analytics possibilities.

Trusted

Ensure data reliability at all times by using high availability to recover from an incident with zero data loss, backed by a world-class 24/7 SRE team. Leverage automated backups to guard against user error. Use cross-region replicas and global VPCs to simplify protecting your data in the event of a disaster.

Customers

Our customers say yes to more, without increasing headcount

Documentation

Find resources and documentation for Cloud SQL for SQL Server

Google Cloud Basics
Cloud SQL for SQL Server features

Learn about the major features and capabilities of Cloud SQL for SQL Server.

Google Cloud Basics
High availability configuration

An overview of the high availability (HA) configuration for Cloud SQL for SQL Server instances

Tutorial
SQL Server instance integrated with Active Directory

Learn the basic steps required to create a SQL Server instance integrated with Microsoft Active Directory using Cloud SQL.

Best Practice
DBA best practices for Cloud SQL for SQL Server

Learn database administration best practices for Cloud SQL for SQL Server.

Tutorial
Migrating data from SQL Server 2017 to Cloud SQL

Learn how to migrate data from SQL Server 2017 to Cloud SQL for SQL Server using snapshot replication.

Pricing

Cloud SQL for SQL Server pricing details

Cloud SQL for SQL Server offers sizes to fit any budget. Pricing varies with settings, including how much CPU, memory, and storage you provision. Cloud SQL offers per-second billing and database instances are easy to stop and start. SQL Server licensing is provided at a separate rate per vCPU/hour by edition.