Azure SQL Database
An Azure relational database service.
5,815 questions
1 answer
I deleted the database, how can I get it back?
hi I deleted the database, how can I get it back?
asked 2024-11-27T11:42:33.2433333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(19.2, 6%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EHA%3C/text%3E%3C/svg%3E)
Hakan AK
0
Reputation points
answered 2024-11-27T12:07:46.9733333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(25.6, 75%, 12%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESG%3C/text%3E%3C/svg%3E)
Shikha Ghildiyal
0
Reputation points Microsoft Employee
1 answer
SQL DB Backup still going on
I am using VM for backup of 450GB data from SQL DB and, I have used Export Data-tier Application option in the Tasks menu because In SQL Server Management Studio (SSMS) the backup option is not showing. The backup process going on for last 15hours Is…
asked 2024-11-27T07:59:27.1633333+00:00
Mohana Reddy
0
Reputation points
answered 2024-11-27T10:28:24.33+00:00
SUNOJ KUMAR YELURU
14,551
Reputation points MVP
1 answer
SQL Server WEB edition for a Public website with password protected CMS
I need to migrate a public website with its own Content Management System to the cloud. Currently, the web application is using SQL Server and I'm trying to understand if I can use the SQL Server WEB edition license offered by both AWS and Azure. None of…
asked 2024-11-27T07:59:20.6466667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(156.8, 11%, 25%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMG%3C/text%3E%3C/svg%3E)
Marco Giorgi
0
Reputation points
edited an answer 2024-11-27T10:07:30.2766667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(198.4, 69%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESR%3C/text%3E%3C/svg%3E)
Sai Raghunadh M
1,210
Reputation points Microsoft Vendor
1 answer
Azure functions dont deploy due to imports
Hi, I have an azure function app with multiple functions, with each function having their own folder and a function_app.py file in the root. The functions share common helper functions which are defined in two separate folders in the root directory - db…
asked 2024-11-26T15:28:08.2266667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(41.6, 53%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAM%3C/text%3E%3C/svg%3E)
Aamir Mogra
0
Reputation points
answered 2024-11-27T10:01:56.6666667+00:00
Pinaki Ghatak
5,075
Reputation points Microsoft Employee
2 answers
after creating login in Azure SQL server, getting error while login to DB using SSMS
Hi, i am trying to connect to Azure sql server using sql authentication. but it is throwing error. i have followed the below steps to create login. Error attached for reference. Thanks CREATE LOGIN [john_doe] WITH PASSWORD = 'MySecurePassword123!'; --…
asked 2024-11-07T08:53:18.8333333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(156.8, 77%, 25%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ELN%3C/text%3E%3C/svg%3E)
Lakshmi Narayana Sarma Bhamidipati
110
Reputation points
answered 2024-11-27T09:39:32.1266667+00:00
Sai Raghunadh M
1,210
Reputation points Microsoft Vendor
1 answer
I'm trying to create a linked service in ADF but get the 'connection failed' error.
I'm trying to create a linked service between ADF and SQL database. I keep getting the following error message when I try to test the connection... Cannot connect to SQL Database. Please contact SQL server team for further support. Server: 'servernov23',…
asked 2024-11-24T08:13:40.71+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(230.39999999999998, 37%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESV%3C/text%3E%3C/svg%3E)
Srinivas V
0
Reputation points
commented 2024-11-27T09:35:45.81+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(288, 61%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EP%3C/text%3E%3C/svg%3E)
phemanth
11,485
Reputation points Microsoft Vendor
1 answer
SQL DB Backup issue
I am using FortiClient VPN for accessing SQL DB. When trying to back up an Azure SQL Database using SQL Server Management Studio (SSMS) the backup option is not showing. So, I have used Export Data-tier Application option in the Tasks menu. Now getting…
asked 2024-11-27T07:51:42.7566667+00:00
Mohana Reddy
0
Reputation points
answered 2024-11-27T09:05:06.91+00:00
Olaf Helper
45,206
Reputation points
3 answers
Upload and restore .bak file to Azure SQL Database from Local Machine
I have a .bak file on my machine I am trying to restore into an azure database. I then created an Azure storage/blob account to hold this file, to restore via ssms but unfortunately, the file is large (about 35GB) and crashes my machine multiple times.…
asked 2024-07-09T09:06:52.5033333+00:00
Babawale Dawodu
110
Reputation points
commented 2024-11-27T08:17:09.92+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(160, 37%, 25%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EHL%3C/text%3E%3C/svg%3E)
Howard Long
0
Reputation points
4 answers
SSRS license on a separate sql server vm
I have a VM on Azure IaaS Sql server 2019 Standard. I would like to install SSRS on a separate VM. Would I need a new license for this?
asked 2024-11-26T16:13:05.8833333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(96, 32%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPR%3C/text%3E%3C/svg%3E)
PHILIPE RIBEIRO MENDONCA
0
Reputation points
answered 2024-11-27T06:20:49.6233333+00:00
Olaf Helper
45,206
Reputation points
0 answers
Azure app server connection To azure vm db server intermittently timeout
we have an app with built in crystal reports and they have saved connection details in the reports. When we click the button to generate, it often works. Every once in a while it will fail and give us "database login failed" which i believe is…
asked 2024-11-22T16:56:43.0366667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(35.2, 8%, 13%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJ%3C/text%3E%3C/svg%3E)
Jackstraw91
0
Reputation points
commented 2024-11-27T05:36:06.2933333+00:00
KapilAnanth-MSFT
47,286
Reputation points Microsoft Employee
1 answer
One of the answers was accepted by the question author.
Discrepancy in Azure Function App Deployment Between Portal and PowerShell
I encountered an issue while deploying a Function App in the East US region: Issue with Azure Portal: Deployment failed with the error: "The template deployment 'Microsoft.Web-FunctionApp-Portal-XXXXXXXX' is not valid according to the validation…
asked 2024-11-25T12:51:22.3166667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(99.2, 2%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETJ%3C/text%3E%3C/svg%3E)
Tiwari, Jyoti
20
Reputation points
accepted 2024-11-27T03:11:29.05+00:00
Tiwari, Jyoti
20
Reputation points
1 answer
Your subscription does not have access to create a server in the selected region
When creating a SQL database, when I try to create a server I get this message: Your subscription does not have access to create a server in the selected region. For the latest information about region availability for your subscription, go to…
asked 2024-11-26T22:40:31.25+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(124.80000000000001, 4%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAM%3C/text%3E%3C/svg%3E)
Andrew Minto
0
Reputation points
answered 2024-11-26T23:19:20.61+00:00
Oury Ba-MSFT
19,651
Reputation points Microsoft Employee
1 answer
One of the answers was accepted by the question author.
Azure Serverless Deep Pause vs Light Pause
Hello Azure Community, I currently have my Azure SQL Serverless database on 15 minutes auto-pause. If the database is inactive for 15 minutes it goes into a light pause, meaning records are fetched in 4-6 seconds instead of the usual 2 seconds on the…
asked 2024-11-26T02:58:38.83+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(160, 41%, 25%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
Axium
0
Reputation points
commented 2024-11-26T22:48:17.73+00:00
Erland Sommarskog
113.2K
Reputation points MVP
1 answer
SSMS firewall rules error
I am accessing my Azure host SQL db from my local machine using SSMS. I have a VPN and I have Firewall rules set on the Azure so evertime my IP adress changes which is daily i have to add a new firewall rule. SSMS does this in a pretty straightforward…
asked 2024-11-22T10:49:09.7333333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(83.2, 18%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJ%3C/text%3E%3C/svg%3E)
Johnm
1
Reputation point
commented 2024-11-26T22:13:44.46+00:00
Erland Sommarskog
113.2K
Reputation points MVP
0 answers
Is reserve pricing available for zone-redundant elastic pools?
Is reserve pricing available for zone-redundant elastic pools? You can make reservations for non-zone-redundant pools but the zone-redundant pool pricing table only includes pay-as-you-go.
asked 2024-11-26T14:03:12.89+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(176, 71%, 27%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EHN%3C/text%3E%3C/svg%3E)
Hoang Nguyen
0
Reputation points
edited a comment 2024-11-26T16:34:49.57+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(227.2, 46%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENN%3C/text%3E%3C/svg%3E)
NIKHILA NETHIKUNTA
3,585
Reputation points Microsoft Vendor
1 answer
How to load multiple different JSON files into Azure SQL DB using Azure Data Factory
Hi all, I am currently working with some nested JSON files and attempting to load it from the blob container to azure sql db using azure data factory. All of the JSON files have different structures as the fields and columns vary in each one, which is…
1 answer
Azure managed instance still updating after scale operation started 5 days ago
I scaled a general purpose managed instance several days ago , but on the overview page for the managed instance,, it is still displaying the following message , 'The resource is still updating please do not create restore databases etc' this is shown …
asked 2024-11-22T09:22:21.0366667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(44.800000000000004, 39%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERT%3C/text%3E%3C/svg%3E)
Redington, Tom
0
Reputation points
commented 2024-11-26T09:05:24.7933333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(35.2, 49%, 13%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EVK%3C/text%3E%3C/svg%3E)
Vijayalaxmi Kattimani
490
Reputation points Microsoft Vendor
1 answer
Connect web app client to web app api
My project is made by ASP .NET MVC call API. Client side will call API to get data. Now I deploy two Web app API and Client to Server. But running client has no data because it cannot connect to API. Please show me how to connect.
asked 2024-11-26T06:22:01.3033333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(211.20000000000002, 88%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENN%3C/text%3E%3C/svg%3E)
Nguyễn Văn Bằng
0
Reputation points
answered 2024-11-26T06:51:00.9166667+00:00
SurferOnWww
3,376
Reputation points
1 answer
Loading large nested JSON files into Azure SQL db using Azure Data Factory
Hi all, I am currently working with large nested JSON files stored inside a blob container. Each file has a different structure with varying fields and data types, and nested arrays. My goal is to load these files into an Azure SQL database in an…
asked 2024-11-22T11:00:34.1533333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(108.80000000000001, 17%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAK%3C/text%3E%3C/svg%3E)
A K
45
Reputation points
commented 2024-11-26T01:49:34.3566667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(99.2, 65%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECB%3C/text%3E%3C/svg%3E)
Chandra Boorla
3,690
Reputation points Microsoft Vendor
1 answer
One of the answers was accepted by the question author.
Azure SQL Managed Instance storage size reduce
Context: I have a SQL Managed Instance General Purpose server with 8v Cores and 8000 GB of Storage. The database is just over 6000 GB in size and after a cleaning and shrink process it should be 4000 GB. Considering this context, is it possible to reduce…
asked 2024-11-25T20:47:56.4033333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(41.6, 36%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDK%3C/text%3E%3C/svg%3E)
Daniel Kobuszewski
20
Reputation points
accepted 2024-11-25T23:36:03.1866667+00:00
Daniel Kobuszewski
20
Reputation points