Create MS SQL Database With Bicep

This blog post will show you how to create a database on a Microsoft SQL server using a Bicep template.

If you need to create a Microsoft SQL server, please use the following post on creating a Microsoft SQL Server using a Bicep Template.

Bicep Template

The following template will create an SQL Database on an existing SQL Server. The template uses the basic tier for the database.

resource sqlDB 'Microsoft.Sql/servers/[email protected]' = {
  parent: sqlserver
  name: 'ntweekly'
  location: location
  sku: {
    name: 'basic'
    tier: 'basic'
  }
}

Processing…
Success! You're on the list.

Leave a comment

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.