Server Fault Stack Exchange
Server Fault Stack Exchange

Questions tagged [azure-sql]

Azure SQL Database is a general-purpose relational database-as-a-service (DBaaS) based on the latest stable version of Microsoft SQL Server Database Engine.

SQL Database is a general-purpose relational database managed service in Microsoft Azure that supports structures such as

  • Relational data
  • JSON
  • Spatial
  • XML

SQL Database delivers dynamically scalable performance within two different purchasing models: a vCore-based purchasing model and a DTU-based purchasing model. SQL Database also provides options such as columnstore indexes for extreme analytic analysis and reporting, and in-memory OLTP for extreme transactional processing. Microsoft handles all patching and updating of the SQL code base seamlessly and abstracts away all management of the underlying infrastructure.

Ask any question related to Azure SQL and read more at https://docs.microsoft.com/en-us/azure/sql-database/

92 questions
0
votes
2 answers

Backing up Azure SQL Server databases to external destination

I run a bunch of Azure SQL Server databases, and they are backed up internally in Azure to storage. This is great for most cases. However, to mitigate risk (if for example, we lose access to the azure account), I would really like to back it up to…
Kjensen
  • 1,009
  • 9
  • 28
  • 39
0
votes
1 answer

how to restore Azure Database for MySQL in azure using data factoryy Destination data store

i want to save data from Destination data store via data factory to blob or some other storage in azure cloud and then get it back to Azure Database for MySQL , but the only options in the UI screen data factory->Author & Monitor ->Destination data…
Omer Anisfeld
  • 111
  • 4
0
votes
1 answer

Error While Creating Azure SQL Server Failover Group

I am trying to implement a failover group in Azure for my SQL servers but I am getting this error while doing so. Further, I have question too. I got to know that Secondary Server should not be in the same region, but I am anxious to know whether it…
hiFI
  • 101
  • 2
0
votes
1 answer

can't connect to my sql DB server

I'm trying to connect to my sql DB in azure with my primary username and password (I don't have any other username and password) and its failed. I'm 100% sure I entered the right username and password. is there anything I can do to connect my…
Itzik Vaisman
  • 1
0
votes
1 answer

Azure Key vault, getting suffice permissions to develop/administrate a customers environment

I need to administer azure key vault for a client to store VM creds, Data Factory creds, SQL creds etc. I have guest account access to their environment, setup with contributor access to the azure subscription we are building the solution in. What…
Font_writing_code
  • 3
  • 2
0
votes
0 answers

Azure mysql server portal shows 150 GB extra used space than actual db size

I'm using azure mysql database, Azure portal shows total of 350 GB of used space but when I analyzed using schema inspector the total size used is 205 GB. what might be cause of extra storage. My assumption are, Azure redundancy Server parameter…
Aki Lan
  • 1
0
votes
1 answer

Autoscaling Azure SQL Database

I'm looking to set up some type of method to autoscale (vertically) my Azure SQL Databases based on CPU or some other performance metric. My environment is in govcloud and I don't see any options for autoscale. I've create a logic app that will…
jrd1989
  • 628
  • 10
  • 35
0
votes
1 answer

Azure Webapp and SQL Secure networking

I believe i'm trying to do simple pretty basic with Azure, yet so far I didn't found anything "safe". Basically, I just want to have a Azure WebApp and a Azure SQL Server (no VMs) communicating to each other, the WebApp been public on internet, and…
frank
  • 133
  • 1
  • 1
  • 5
0
votes
2 answers

Convenient way to dump Azure SQL DB database

Using geo-replication is a nice way of duplicating data but it requires the two servers to be registered on the same Azure account. That could be a potential security risk if an employee decides to log in and delete both servers. In that case there…
judehall
  • 123
  • 5
0
votes
1 answer

Pricing for SQL database/ per SQL server

I'd like to know if I'm doing something wrong about Price Tiers and SQL Databases. Is the price paid per server or per database? I thought it was per database, só if I get a client, they can pay X per as a sample a 10 DTU sql server, and inside I…
Karko
  • 1
0
votes
2 answers

AZURE SQL DATA IMPORT

I want to move data from one azure sql database to new azure sql database. From the first one I have exported .bacpac file. I import it to the second one and I get Import operation for failed. ErrorCode: N/A ErrorMessage:…
Marek Szmalc
  • 101
0
votes
1 answer

Azure ARM Template - multiple Microsoft.Compute/virtualMachines/extensions for VM

I am trying to do auto restore of a bacpac to azure mssql VM when it is provisioned but failing to do so using custom scripts extensions. I generated the Azure MSSSQL VM ARM template using automation scripts in portal and If I see this in detail, i…
Rajan Bhayana
  • 53
  • 9
0
votes
0 answers

Error moving Sql Server Azure between subscriptions

I’m trying to move a SQL Azure Server that has 2 databases from one subscription to another. The databases’ sizes are 10G and 1G. I’m using the azure portal to do it and I’m getting the following error -> There was an error moving…
Copeleto
  • 113
  • 2
0
votes
2 answers

Azure IaaS Client VM to PaaS SQL Connection Issues

I'm trying to get a website hosted on Azure IaaS VM to communicate with a database hosted on Azure PaaS SQL. However, I am receiving an exception when trying to connect: A network-related or instance-specific error occurred while establishing a…
MichaelFStarke
  • 1
  • 1
0
votes
2 answers

SQL Azure used by Azure VMs, Encrypted connection or virtual network?

We Have an Azure SQL Server which is going to accept connections from four VMs also in Azure. My question is, Which one is better? Using encrypted connections protected by certificates and Azure SQL listening on a public port? Using non-encrypted…
morgano
  • 123
  • 1
  • 7
1 2 3
4
5 6 7