Questions tagged [sql-server]

Questions related to Microsoft SQL Server. If your question is version specific please tag it specifically for that version as well. Does your SQL Server question belong here or on another site? Click the about the sql-server tag link on the line below.

Filter by
Sorted by
Tagged with
0
votes
2answers
18 views

Copying SQL Server settings to new server

We are a small business using a single SQL Server 2014 instance as our main data platform. We now need to set up a second instance (2017) to hold additional data - this is to be standalone, ie not ...
2
votes
0answers
18 views

Suggested indexes

I am new to indexing in general and have just started learning about query plans etc. I am working on this one specific query that keeps advising me to create the following index: CREATE NONCLUSTERED ...
0
votes
1answer
52 views

IIS and SQL 100% CPU Usage

We have an IIS server running an ASP.net application and SQL Server. Most of the time it runs fine, but recently we have had a couple of instances of severe performance degradation. The whole site ...
1
vote
2answers
39 views

Cannot connect to the MS SQL Server 2014 from a remote machine via named pipes

I installed MS SQL Server 2014 on a machine that had an MS SQL Server 2012 default instance. On the local machine, I can connect to both instances using named pipes. However, from a remote client, I ...
0
votes
1answer
16 views

Apache is getting SUSPENDED in MSSQL by another process when doing more than 5-6 queries via PHP PDO resulting in timeout

I will try to be as detailed as possible. Up until now I was only using Stack Overflow and other sites like this but never posting. I was always able to find the answer to my question. But not this ...
0
votes
0answers
25 views

Azure data migration project issue — AWS VM to ManagedInstance

I've been tasked with migrating a set of databases that are hosted on a single AWS VM (not RDS) running SQL Server 2012 (pre sp1... version string in SSMS is 11.0.2395.0) to Azure. Unfortunately, the ...
34
votes
7answers
8k views

Can Microsoft employees see my data in Azure?

I have sensitive data stored in both Azure DB and Azure SQL VM. An authorised DBA can log on and query the database, but in theory could a random Microsoft employee do the same without asking ...
0
votes
2answers
29 views

TDE vs Disk Encryption

We are a small business that host applications and data for clients. Some of our clients are requesting we protect their data with 'encryption at rest' - although it's never very clear if they know ...
-1
votes
0answers
16 views

Can you Identify the sql server name from sql backup file(.bak)? [migrated]

I have a backup file from an SQL 2016 server and I need to identify which SQL server the file was created on. Is there a way to identify the original SQL server where the file originated at? Thank ...
0
votes
0answers
4 views

‘PRIMARY’ filegroup is full. How do I increase temdb size in SQL Exress 2017? [migrated]

When I reindex a particular table DBCC DBREINDEX(@TableName, '',90) I get an error Level 17, State 2, Procedure aareindex, Line 21 [Batch Start Line 0] Could not allocate space for object ‘...
0
votes
0answers
27 views

Why does SQL Server keep creating the folder “C:\Program Files\Microsoft SQL Server\” when installing on another driver?

I specified a different drive wherever applicable during the SQL Server 2017 install. However, the directory C:\Program Files\Microsoft SQL Server keeps getting created. I basically have the expected ...
0
votes
0answers
37 views

Very High Network bandwidth usage (almost 20 GByte/Hour) Windows server 2012 R2

My server provider sent me an email with PRTG network moniter report saying that my outward traffic volume is too high (say 15GByte/Hour). I checked my network consumption with resource monitor ...
0
votes
2answers
55 views

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 ...
0
votes
1answer
71 views

Windows Memory Usage - Is something throttling available RAM

Can anyone tell by the images below if this machine is unnaturally throttling memory usage. The memory was upgraded from 32GB-64GB for SSRS report rendering, which is the only sizable process to run. ...
0
votes
0answers
6 views

INSERT values from .csv into database [migrated]

We have a sybase database running an application our users use which contains client info. The situation is that address information for maybe 1000 clients or so is out of date. We were given a .csv ...
1
vote
1answer
105 views

256TB, GPT disk, I can, but should I?

I just learned (thank you Kevh) that a GPT drive on Windows can hold 256TB Unlike MBR that limits each partition to only 2TB in size, each partition in GPT can hold up to 2^64 blocks in length (...
0
votes
0answers
35 views

Unable to access SQL Server on the Host Machine from SQL Server Management Studio in the Guest VM

Using VMware Workstation 15, should I be using host-only for my scenario below? I need to access SQL Server, hosted on a Windows 10 host, from a Windows 10 Guest VM, without giving the Guest VM ...
0
votes
0answers
107 views

Attaching to an existing DB fails - folder keeps setting itself to read only

Having found no solution to the network problems I suddenly encountered, I uninstalled MSQE but left the MDF files in place. I then re-installed a fresh 2014 and started it up with a test DB from a ...
1
vote
1answer
45 views

Suddenly my local SQLServer is kicking named pipe errors

I have a local instance of 64-bit SQL Server Express 12.0.something. I use it for local tests of our SQL code. Today, out of the blue, I get: Additional information: A transport-level error has ...
0
votes
1answer
38 views

Microsoft SQL gradually increasing RAM consumption while using my website

I'm developing a website hosted on Apache 8.5 that connects to a Microsoft SQL server using Hybernate and the entity/dao/bean structure. When I start the server where MS SQL is located and open the ...
-1
votes
1answer
70 views

SQL Server 2019 RC in Production? [duplicate]

I have a MS SQL Server 2008R2 running our two main databases. I have a few problems with MS SQL Server 2008R2, and would like to upgrade ASAP. i did however not get the funds to buy a 2017, only for ...
1
vote
2answers
133 views

How to find missing permission in MS SQL server

Problem description: I am trying to use SQLDependency on a table of a commercial product (TAC Reservation Assistant). The DB is a large Microsoft SQL 2016 database on which we don't have db_owner ...
0
votes
1answer
32 views

Email notification when login attempt fails on RDS SQL Server DB

I need to get notified when there is an attempt to access our SQL database with the incorrect credentials. Is this something that I can do in AWS or do I need to do it in SQL Server? I can manually ...
0
votes
0answers
44 views

Next step when DBCC CHECKDB REPAIR_ALLOW_DATA_LOSS failes

I'm in a situation where a few Tables of a Database (MSSQL2016 - 13.0.5081.1) are corrupted (selecting data failes at some point) There is no valid backup available (the error seems to be present in ...
0
votes
0answers
18 views

Alter database blocked by -2

We have a database that we can't restore because any alter database to put it into single_user mode (or offline) will fail because it is blocked by a distributed transaction. sp_lock -2 shows the ...
0
votes
0answers
37 views

OLE DB Driver for SQL Server on Windows 10: only 64 bit?

I'm trying to install SQL Server OLE DB Driver 32 bit on a Windows 10 (64 bit) via the downloaded instaler: msoledbsql_18.2.2.0_x86.msi. I get the message: Microsoft documentation says that on ...
0
votes
1answer
18 views

How to connect Azure Database migration service with on premise based source SQL server

I am trying to connect Azure Database migration service with SQL server which is in On premise VPN. Not able to establish the connection.
1
vote
0answers
26 views

Docker SQL Server remote login from IIS login failed for user sa

I have this error when I trying to connect ASP Classic web app (hosted in IIS 10) to SQL Server 2014 with username and password using a DSN configured in IIS dockerfile: Microsoft OLE DB Provider for ...
0
votes
0answers
8 views

Azure data sync

I have a SQL server on premise, and a Azure instance of SQL Server. I am working through the implementation guides, but this one question, i have not found a solid answer to. If the connection fails ...
3
votes
1answer
270 views

SQL Server 2016 remote access denied

I have two VM with an SQL server on each and I need to connect to both SQL servers from each machine, either from SSMS and with PowerShell script. Also, today I don't manage to do that I'm always ...
0
votes
1answer
39 views

Is this an IIS issue or a Database Issue? Non Concurrent collections must have exclusive access

I am using asp.net core api with EF core and today I got this error message and it confuses me as of why it could have happened. Operations that change non-concurrent collections must have exclusive ...
0
votes
0answers
19 views

Is there is a way to configure SQL Server 2014 cluster to keep the same DB ids when switching between nodes?

The DB has different id on SQL Server nodes, and it a problem because our license depends on db id. Is there any way to configure the cluster to keep the same id on both nodes? Thank you!
1
vote
0answers
56 views

Restore AWS RDS Database with memory optimized Filegroup in Amazon S3

Can't restore AWS RDS database that has memory-optimized data. I have a backup in S3 and when I try to do a restore into RDS: exec msdb.dbo.rds_restore_database @restore_db_name='MyDatabase', ...
0
votes
1answer
58 views

Can db corruption occur from power loss even with battery backed write cache?

Datacenter power outage and we are awaiting restore. Our database server has battery backed write cache. Does that completely eliminate the chances of db corruption from primary power loss?
0
votes
1answer
128 views

Azure sql server cannot create database

I am trying to create a database in Azure SQL server. However, when I try to create it, it prompts "Gen4 family is not available in this region" and cannot create the database. What is the problem?
1
vote
0answers
22 views

Best practices for updating a Windows Failover cluster / SQL Server Availability Group without using Cluster-Aware Updating

I have set up an SQL Server 2016 Availability Group inside a Domainless Windows Server 2019 Failover Cluster. Everything runs fine at the moment, but now I am wondering what might happen if cluster ...
0
votes
0answers
7 views

Where is v_GS_SoftwareUsageData

I am trying to write a custom report on SCCM which will query the metered software products. When I create a report using report builder I am connecting to the report server database instance. When ...
0
votes
0answers
19 views

How to improve the performance of rds located in different region

I have an AWS Microsoft SQL server in US region.The server is being used by people in Asian region also.But the DML queries take lot of time to execute in the Asian region. Should I create another SQL ...
1
vote
1answer
39 views

Sudden Disk Issues During Database Restore

Environment: Azure Windows 2016 VM with SQL Server 2016 Standard installed Machine Size: DS12_v2 (previously DS3_v2, which is the same except for less RAM) 4-cores 28 GB RAM 14 GB RAM for SqlServer ...
0
votes
2answers
55 views

How to scrub or clean out company data before selling server

I'm looking to sell a used Dell Poweredge T310 server (Specs at the end) with Server 2008 Standard SP2 and MS SQL Server 2008 R2 on it. I'd like to sell the server as-is, with the OS and installed ...
1
vote
1answer
37 views

What is the best automated ETL method to transfer data from SQL Server IN cloud (AWS) to SQL Server NOT Cloud?

We have 2 SQL Server databases. One of them is to be moved to AWS cloud. Is Amazon RDS the ONLY approach to move the SQL Server to AWS? What is the best way to automate data transfer of table data ...
0
votes
1answer
49 views

Why is SQL Server 2017 Web Edition capping at 25% CPU usage?

I am using Microsoft SQL Server 2017 Web Edition in a virtualized environment hosted on Amazon EC2. Per Microsoft's Editions and supported features of SQL Server 2017 page, the "Maximum compute ...
0
votes
0answers
38 views

How to create a keytab file for SQL server SPN and use it in my java application?

I have some doubts regarding generating a keytab file for SQL server kerberos authentication. SQL server's SPN is: MSSQLSvc/myhost:1433@MYDOMAIN.COM I have created keytab file as: ktpass -out "C:\...
1
vote
1answer
59 views

Save SQL Server transaction logs to network share

We are running our ERP software on a SQL Server 2016 server as a VM on VMware ESXi. Presently, we have the VM configured with 2 drives, with data going to 1, and logs to the other. We had a problem ...
-2
votes
2answers
131 views

SQL server in networks

a network consists of a lot of servers like web server, DNS server, FTP server , ... but i confused about SQL server. SQL server is used to store data. my first question: is SQL server a separate ...
0
votes
0answers
22 views

Allow a Serverless application to access a database present on a different VM

I want my serverless Azure application to access an SQL database present on a different Virtual Machine. Another requirement is that I want to use my Azure username and password but I cannot use runas ...
0
votes
1answer
45 views

Should Active Directory, Web Apps and MS-SQL all have the same users?

I am looking for a clean way to do audit trails in MS SQL Server, for compliance reasons, preferably completely on the database side without involving the web application. When talking about audit ...
2
votes
2answers
71 views

SQL Server, any advantage to dual RAID controllers?

We're setting up a new Hyper-V server, primarily to host a SQL Server VM, and the question came up, how much advantage is there if we used two RAID controllers instead of one? For the responsiveness ...
0
votes
1answer
234 views

Installing MSSQL for Linux on Debian Buster (SSL 1.0??)

Would love to run my MS-SQL on a Debian Buster server but there are some obstacles. First of all the installation has dependencies not available in the Buster repository, one is the old libssl1.0.0 (...
0
votes
2answers
518 views

How do I test connection from Linux to Microsoft SQL Server?

What's the simplest way to check connectivity from a Linux server (e.g. Ubuntu 18.04) to a remote Microsoft SQL Server 2017 instance?