THE SQL Server Blog Spot on the Web

Welcome to SQLblog.com - The SQL Server blog spot on the web Sign in | |
in Search

The Bit Bucket (Greg Low): IDisposable

Ramblings of Greg Low (SQL Server MVP, MCM and Microsoft RD) - SQL Down Under

Auto-delete Azure SQL Database Servers with no databases

In Windows Azure SQL Database, a database "server" is a logical concept that's used to keep details of connected databases. It does have a "master" database but it's not like the on-premises equivalent. It's pretty much a container for logins.

Generally there is no point provisioning a server that has no databases. Servers aren't charged separately, only the user databases are charged for.

The Azure team has now made a change that means that if you have a server that hasn't had any user databases within the last 90 days, it will be automatically deleted. It's important to be aware that this can happen. The only thing that would be lost would be any pre-configured logins. You would need to recreate them when you later decide to provision a user database.

Published Wednesday, September 25, 2013 11:00 AM by Greg Low

Comment Notification

If you would like to receive an email when updates are made to this post, please register here

Subscribe to this post's comments using RSS

Comments

No Comments

Leave a Comment

(required) 
(required) 
Submit

This Blog

Syndication

Tags

No tags have been created or used yet.
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement