Server Fault Stack Exchange
Server Fault Stack Exchange

Questions tagged [sql-server-2016]

63 questions
14
votes
1 answer

Parallel Redo Is Shutdown

When looking in Windows event logs, i'm seeing the following messages on an almost continuous basis - Starting up database 'Database'. Parallel redo is started for database 'Database' with worker pool size [1]. Parallel redo is shutdown for…
Gavin Coates
  • 410
  • 1
  • 6
  • 17
8
votes
1 answer

The setup of S2D that delivers up to 2M IOPS to SQL FCI

We are about to deploy shared storage researching for ultra-fast storage to implement Microsoft SQL Server Failover Cluster (FCI). So far the project goes, we would to start with 500K IOPS for 8k blocks about 70r/30w pattern. Also we would like to…
Joshua Turnwell
  • 530
  • 3
  • 12
7
votes
2 answers

SQL on Server Core pitfalls

We are going to try new SQL Server 2016 and we're thinking to install it on Windows Server Core. I know there are some benefits from going this way. From what I've heard, this setup is more secure and it is much easier to manage. But are there any…
B.J.Goodman
  • 454
  • 2
  • 6
4
votes
1 answer

What may increase the latency 3-4 times for SQL FCI the database?

We have SQL Server Basic Availability Groups (BAG) configured to run an SQL database running over local Intel SSD drive. I was asked to move a database to SQL Server Failover Cluster Instance (FCI) to increase the SQL Server performance: run the…
A.Newgate
  • 1,476
  • 5
  • 11
4
votes
3 answers

SQL Server 2016 Web Backup to URL

I recently stood up a new Windows Server 2012 R2 instance with SQL Server 2016 Web Edition and am trying to setup automated backups to Azure, but not having any luck. I created the storage account on Azure first, then created the Shared Access…
Scott Salyer
  • 297
  • 4
  • 14
3
votes
0 answers

How can I completely uninstall SQL Server 2016 and everything that it installed?

I installed the Express edition of SQL Server 2016 to test and I now want to uninstall it and everything that it installed on this server. I have SQL Server 2014 installed and do not want that affected by the uninstall. Am I safe to remove…
Jack
  • 41
  • 1
  • 4
3
votes
1 answer

Error installing SQL Server 2016: "The specified user does not exist"

It's been a whole saturday since I'm trying to install SQL Server 2016 without success. My procedure has been the following (I always start by uninstalling all sql server instances before trying again): Download…
Luis Gouveia
  • 211
  • 1
  • 3
  • 8
3
votes
1 answer

Why does TFS need an SQL Server Instance?

It's been over 3 years since I am using TFS 2012 for source code management, reporting and project management. However, until now, I've never installed from scratch any version of TFS. In order to use SSRS 2016, I need to install TFS 2015, and by…
Luis Gouveia
  • 211
  • 1
  • 3
  • 8
3
votes
1 answer

SQL Server Always On Availability Group Zero Downtime Update Procedure

Here I have a 2-node SQL Server 2016 AlwaysOn Availability Group cluster, with 1 primary and 1 secondary. The question is - what is the optimal way to install Microsoft Updates on the servers in the cluster? I have struggled to find good, clear…
A X
  • 382
  • 2
  • 8
  • 23
2
votes
2 answers

Failover SQL cluster to DR site using replication

I am attempting to fail over a SQL cluster with 2 nodes using Zerto replication. I am running Server 2016 Standard and SQL 2017 standard. My network is not stretched, so I need to failover using a different vlan. I am only attempting to bring up…
oke
  • 21
  • 2
2
votes
1 answer

SQL SVR 2016 - Relocating system databases to different drive (Invalid directory error Msg 5121)

I have a fresh install of SQL Server 2016 which i'm trying to relocate the system databases onto a different drive on the machine Drive:D I've ran the following commands but keep getting the same error. The only issue I can think of is the file…
UserSN
  • 157
  • 3
  • 16
2
votes
0 answers

Does SQL Server 2016 Support Windows Server 2016 Essentials?

The Requirements for SQL Server 2016 list the following operating systems as being supported: Windows Server 2016 Datacenter Windows Server 2016 Standard Windows Server 2012 R2 Datacenter Windows Server 2012 R2 Standard Windows Server 2012 R2…
Gavin Coates
  • 410
  • 1
  • 6
  • 17
2
votes
2 answers

SQL Server Bulk insert over UNC path failing, despite full access

I have a setup with 2 machines (client on win2012r2, sql server on win2016) which are both not part of a domain. The client machine has a share, accessible to Everyone. I'm using SQL Server authentication. I'm able to browse the share from the SQL…
Koert
  • 133
  • 1
  • 5
2
votes
1 answer

Cannot generate SSPI context SQL Server 2016

First post here :) I've been trying to connect to a SQL server 2016 in a pc using SSMS 2016, both EXPRESS editions. Server shows up in Network Servers window. I'm trying to connect with HOSTNAME\SERVERNAME and Windows authentication , I already…
João Sequeira
  • 21
  • 1
  • 4
2
votes
1 answer

How to debug the cause of my suddenly extremely slow running database backups maintenance plan?

(Originally posted on DBA.StackExchange.com but closed, hopefully more relevant here.) Alexander and the Terrible, Horrible, No Good, Very Bad...backups. The Setup: I have an on-premise SQL Server 2016 Standard Edition instance running on a virtual…
J.D.
  • 121
  • 3
1
2 3 4 5