Beyond Migration: Using Database Migration Service for disk shrinking

TL;DR

Google Cloud's Database Migration Service (DMS) enables SQL Server users to shrink disk space with minimal downtime, transforming traditional database migration into an ongoing operational tool. This capability allows for efficient storage management in production environments.

✦ Why It Matters

Consider using DMS for ongoing database maintenance to optimize storage and reduce downtime.

Key Takeaways

Use DMS for continuous database replication to minimize downtime.
Shrink disk space after data archiving or purging to save costs.
Prepare server-level objects manually before cutover to avoid issues.
Re-map orphaned users post-cutover to ensure database access.

How It Works

DMS replicates databases by first taking a full backup and then continuously applying transaction log backups to keep the target instance synchronized. This allows for a new instance with a smaller disk to be provisioned while the original instance remains online.

Beyond Migration: Using Database Migration Service for disk shrinking

Shutting the Door on the XCPE Botnet

The Rise of LLMJacking: How Threat Actors Monetize Compromised Cloud and Model Resources

Heimstaden is changing residential real estate management with AI

How “reverse game theory” could keep AI agents in check

Shutting the Door on the XCPE Botnet

The Rise of LLMJacking: How Threat Actors Monetize Compromised Cloud and Model Resources

Heimstaden is changing residential real estate management with AI

How “reverse game theory” could keep AI agents in check