Database Administrators Stack Exchange
Database Administrators Stack Exchange

Questions tagged [azure]

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.

384 questions
10
votes
3 answers

How do I drop a database which has brackets in its name?

I have a database which has brackets in its name. (Don't ask! :-\ ) It shows in SSMS but not in Azure because it was canceled while creating. It does not show in the database listing in Azure. It shows in SSMS but it cannot be deleted by…
Yossi Geretz
  • 349
  • 1
  • 11
7
votes
2 answers

AlwaysOn AG versus FCI

Throughout MS documentation for AlwaysOn Availability Groups (AG) and AlwaysOn Failover Cluster Instances (FCI) I see the following pattern: FCI is for HA scenarios. An AG synchronous secondary replica, co-located with the primary, is for HA…
Brent Arias
  • 191
  • 1
  • 1
  • 5
6
votes
1 answer

Azure SQL DB vs Azure managed instance

We are in the early stages of planning to move some of our on-premise database to cloud and wanted to go the PaaS way. I understand that managed instance is in preview. From what I have read, ignoring the cost, is there any reason why not to go…
Azuremigration
  • 61
  • 1
  • 2
6
votes
3 answers

The transaction log for database is full due to 'OLDEST_PAGE'

We have a database hosted on azure. It is part of an azure elastic pool. From yesterday all our database operation are consistently failing with following error. The transaction log for database is full due to 'OLDEST_PAGE' We checked for all…
Ketan
  • 497
  • 3
  • 6
  • 14
6
votes
3 answers

Azure SQL Database Restore after Server Failure - Where are the Backups?

According to this article, an Azure SQL backup can be used to "Restore a database to another geographical region. This allows you to recover from a geographic disaster when you cannot access your server and database. It creates a new database in any…
Randy Minder
  • 2,032
  • 4
  • 22
  • 41
6
votes
2 answers

IS_MEMBER() in Azure SQLDB not working for AD groups?

I am trying set up RLS and want to leverage AD groups. DB is created in Azure, and I know AD is working as I can connect using AD acount with SSMS First test Local Machine, is working as expected (img 1) Now try Azure The IS_MEMBER() appears to…
Mark West
  • 61
  • 3
5
votes
2 answers

MS Azure Mysql flexible server consumes all Memory

I have MS Azure MySQL Flexible server running in Azure with 4vCPU and 32GB of RAM. It consumes all memory it gets and definitely is choking at lower configurations than 32GB, which seems to be an overkill for the use. Most of the workload is…
ArUnio
  • 51
  • 2
5
votes
2 answers

Azure postgresql really slow compared to VM

I work with postgresql (and Postgis) for years now on a VM with dockers, and I start to be used to tweak servers parameters and optimize request, and I never had the kind of problems I have with Azure Postgresql. The problem is the following:…
robin loche
  • 150
  • 1
  • 4
5
votes
0 answers

Azure SQL Managed Instance - Reboots - places to look?

We have been seeing what appears to be reboots on our SQL Managed Instances (Standard, Failover Group). One node (the current primary, USEast) has been apparently rebooting for the last 24 hours, between 30 minutes and 2 hours between cycles. This…
Jonathan Fite
  • 9,414
  • 1
  • 25
  • 30
5
votes
1 answer

Can Azure Backup Server backup databases participating in Log Shipping?

We have a number of log-shipped SQL 2017 databases which we wish to start backing up using Microsoft Azure Backup Server (locally and to the cloud) on a 15 minute schedule. Does anyone know if it is possible for Azure Backup Server to hook into the…
Mark
  • 941
  • 1
  • 8
  • 20
5
votes
1 answer

Service Principal as SQL Active Directory Admin, does it use Graph API?

I'm looking to use a service principal as the server admin, so it can be used in a release pipeline to create further active directory users. I'm successfully able to make the service principal the server admin* and connect to the database using an…
Alex KeySmith
  • 297
  • 1
  • 4
  • 16
5
votes
3 answers

Grant access to only one key in azure keyvault

There are multiple keys and secrets in azure key vault . I need to grant a user access to only one key and secret in azure portal. Is that possible?
deepak
  • 117
  • 3
  • 7
5
votes
1 answer

Azure Postgresql hitting 100% memory usage without easy way to restart the server

I have recently noticed an issue when using Azure Database for PostgreSQL where my memory usage keeps growing, and upon hitting 100%, the server will stop responding. This database server is used exclusively for development, so it has a lot of…
José Maia
  • 53
  • 1
  • 5
5
votes
2 answers

Why is my UTF-8 document raising UTF-8 encoding errors in Azure Data Lake Analytics?

I have a document that was compressed in gunzip from a unknown source system. It was downloaded and decompressed using a 7zip console application. The document is a CSV file that appears to be encoded in UTF-8. It's then uploaded to Azure Data Lake…
Fastidious
  • 496
  • 1
  • 7
  • 15
5
votes
3 answers

CREATE DATABASE AS COPY does not work with Azure

I'm new with T-SQL and MSSQL but need to copy Azure SQL database from one server to another. As I googled here - it can be done with a CREATE DATABASE Database1_copy AS COPY OF server1.Database1; query, but in my Vusial Studio Code editor on the…
setevoy
  • 227
  • 1
  • 2
  • 10
1
2 3
…
25 26