I'm using Azure and I have a resource named "Prices_WebSite" which is categorized as an *SQL Database*. I utilize this database for updating our prices via SSMS. Additionally, there's another resource called "WebSite" that is labeled as *SQL Server*. I'm unsure of its role. Are these two resources interconnected in any way? If I delete the *WebSite* resource categorized as *SQL Server*, will it impact the functionality of my *Prices_WebSite* database?
5 Answers
It can be a bit tricky since there are different resource types in Azure. You can't have an Azure SQL Database—meaning the one that incurs costs—without also having an Azure SQL Server, which is essentially a free resource needed for organization and security settings. It's a bit convoluted, but understanding this hierarchy can help clear things up.
SQL Servers can host multiple SQL Databases, so yes, they are indeed related. The database is like a component of the server. Think of it as a part of a bigger machine.
Honestly, it feels like you could've found this info online. It’s probably best not to delete anything until you're completely sure about its connections. Consult with someone who has more experience if you're unsure.
No, the two aren't directly related in a way that one depends on the other for operation. Deleting the SQL Server resource can lead to confusion but won't necessarily affect the database immediately, just keep that in mind.
Yes, your SQL database relies on the SQL server. They're definitely linked! Without the SQL Server, your SQL Database wouldn’t function. You can think of it like this: the SQL Server is the hosting environment for your database.
But wait, in Azure, isn't it possible that the SQL setup is as a service? That might mean you don’t interact directly with the SQL server itself.
But what about the confusion around the names? They offer both "SQL Database" and "SQL Server Database"; how does that fit together?
True, but if they offer both types, what’s the difference between a "SQL Server Database" and just a "SQL Database"? Just trying to clarify that.