Azure / SQL Server / Create DB on Azure
Posted by Barac in Azure, SQL Server on Oct 30th, 2017 | 0 commentsFirst of all, we need to login to Azure Portal and to create Logical SQL Server on Azure
Next, we need to put the name of the server, as well as server admin login account for this Azure Logical SQL Server.
After that, we can create a new one or to use existing resource group.
When we finish this part of configuration we can start with creating Azure SQL Server Database.
We need to define database name, and subscription we want to use for this SQL Database
After that, we need to select source of our database (blank, sample, or restore from backup)
Than we need to choose previously created SQL Server or to create new one if we want.
Next step is to choose do we want to use SQL Elastic pool (I did not use this option for this example)
Following step is to choose Pricing tier we want to use. You can find out more about that here
That is all, now we have our SQL Server and blank SQL Database created.
Next step is to connect to our database using SSMS.
Similar Posts:
- Azure / SQL Server / Azure DB / Add Logins, Users, Permissions
- Azure SQL Managed Instance / Database Migration Service (DMS) / Online Data Migration / Migrate your database to Azure SQL Managed Instance
- Azure / SQL Server / Azure SQL Database Disaster Recovery / Orphaned Users / Different SIDs
- Azure / SQL Server / Rename an Azure SQL database
- Azure / SQL Server / Cannot open user default database (Login failed)
About Me
My name is Zoran, currently living in Auckland, New Zealand. I am a data specialist with more than 15 years of hands-on experience in database administration and optimisation. I am also, Certified Microsoft Trainer (MCT) and Microsoft Certified Solutions Expert (MCSE) with a Master‘s degree in Information Technology. Sharing knowledge and contributing to the SQL Server community is my passion. I am also an organiser of the Auckland SQL User Meetup Group. As well I am active blogger and speaker at different SQL events such as SQL Saturdays, Meetups etc.
read moreAuckland SQL Group
MSDN PROFILE
SQL SERVER UPDATES
- Microsoft SQL Server 2022 Updates / Release Candidate (RC 1) Evaluation Edition (16.0.950.9)
- Microsoft SQL Server 2019 Updates / BETA (15.0.1000.34) / RTM (15.0.2000.5)
- Microsoft SQL Server 2017 Updates / RTM (14.0.1000.169)
- Microsoft SQL Server 2016 Updates / RTM (13.0.1601.5) / SP1 (13.0.4001.0 or 13.1.4001.0) / SP2 (13.0.5026.0 or 13.2.5026.0) / SP3 (13.0.6300.2 or 13.3.6300.2)
- Microsoft SQL Server 2014 Updates / RTM (12.0.2000.0) / SP1 (12.0.4100.1 or 12.1.4100.1) / SP2 (12.0.5000.0 or 12.2.5000.0) / SP3 (12.0.6024.0 or 12.3.6024.0)
- Microsoft SQL Server 2012 Updates / RTM (11.00.2100) / SP1 (11.0.3000.0 or 11.1.3000.0) / SP2 (11.0.5058.0 or 11.2.5058.0) / SP3 (11.0.6020.0 or 11.3.6020.0) / SP4 (11.0.7001.0 or 11.4.7001.0)
Leave a Reply