Microsoft Azure is a Platform as a Service and Infrastructure as a Service cloud computing platform. Use this tag for database administration questions involving Azure. General server help can be obtained at Super User or Server Fault.
Questions tagged [azure]
367 questions
2
votes
1 answer
How can I move a database from OnPremise to Azure using SSMS?
I have a large database, about 6Gig in size , its a .bacpac file and I want to copy it to Azure. I am using SSMS and selecting "Import Data-tier Application".
It takes a very long time and i get an error "System out of memory exception"
How can I…
Renee
2
votes
2 answers
Azure SQL query never completes
I am having an issue with a SQL query that runs and runs but never completes. The database is an Azure SQL database.
My table has tens of millions of rows and looks like this:
CREATE TABLE [dbo].[MyData](
[CustomerId] [int] NOT NULL,
[TagName]…
Roger
- 23
- 2
1
vote
1 answer
Copy Azure premium storage to standard storage for redundancy
For our SQL servers we run backups onto a shared premium storage disk. Premium storage is locally redundant and I would like to copy these backups to a standard storage disk in order to take advantage of it's Geo-redundancy. What is the best way to…
Peuge
- 209
- 1
- 9
0
votes
0 answers
Microsoft SQL Data Sync 2.0 Agent not listing any databases since server move
I have SQL Data Sync set up to keep a few databases installed in a remote data centre synchronised to an Azure SQL dB used for BI reporting.
Recently the physical SQL server on the data centre side was replaced and all the databases on it detached…
James Lee
0
votes
0 answers
Trying to speed up production build using Gradle with Azure Devops
https://docs.microsoft.com/azure/devops/pipelines/ecosystems/android
pool:
vmImage: 'macos-latest
steps:
-task: Bash@3
- displayName: Check for skippable builds
inputs:
targetType: 'inline'
script: |
if [ -z $(apk_flavor_prod)…
DarraghM
- 1
0
votes
0 answers
MariaDB in Azure Converted to Read-only mode
We have a MariaDB instance in Azure following the specs
General Purpose, 2 vCore(s)
Auto Scale in Size
No Read-Replicas
Previously It was in 10GB, after adding a couple of queries, the storage percentage went above 95%. Hence Autoscale is on, and…
Abdul Hakeem
0
votes
1 answer
Not able to restore a database with multiple backup files from Azure blob storage (block blobs)
I was testing the backup with multiple backup files (6) and I was able to successfully take backup for one of my large database (3TB) to my azure storage account by using MAXTRANSFERSIZE, BLOCKSIZE parameters.
Then I tried to restore the database…
Laxmikanth G
- 11
- 2
0
votes
1 answer
Ephemeral disk on Azure LS series
I am little confused about the ephemeral disk on LS series Azure VM.I want to suggest L32s_v2 series vm for a customer due to high iops and throughput that the nvme disks provide but there is a catch. if vm is stopped from portal all the data on…
deepak
- 117
- 3
- 7