SQL Server 2016 - Administration

• Topics

  Started by

  Posts

  Last post

• unable to query sysmanagement_shared_registered_servers_internal

  HI  I have just started to use Central management Services.  I've registered a central se…

  debbie.coates 10909

  5 replies

  6 years, 11 months ago

  By: debbie.coates 10909

• SQL 2016 Azure VM and restoring from Storage Account

  Hi I have deployed SQL 2016 Enterprise in Azure IaaS. I created a VM and installed SQL 2016 onto. F…

  Raxso1

  4 replies

  6 years, 11 months ago

  By: e4d4

• upgrade from 2014 to 2016

  we need to migrate our sqlserver 2014 to 2016this is the current situation:2 nodes active-passive m…

  sgt500

  10 replies

  6 years, 11 months ago

  By: Michael L John

• Database stuck in encryption_state 5 percent_complete 0

  Steps I've tried:Restarting the decryption dbcc checkdb (no corruption left.. although there was pr…

  oogibah

  2 replies

  6 years, 11 months ago

  By: Sue_H

• Session stuck in killed\roll back

  One of the session that is executing a stored proc from an application is stuck in the killed\rollb…

  Feivel

  15 replies

  6 years, 11 months ago

  By: Jeff Moden

• Database stuck in recovery

  One of our database is stuck in recovery for a very long time. The database got corrupted and after…

  SQLNewbie_01

  7 replies

  6 years, 11 months ago

  By: Michael L John

• Cannot bring the Windows Server Failover Clustering (WSFC) resource (ID '38e4748b-1b06-4017-9c3a-e7eb3f45cb2c') online (Error code 5018).

  I am getting below error messages...granted the sysadmin to the respective login and granted the pr…

  databases.specialist

  4 replies

  6 years, 11 months ago

  By: Rick-153145

• Slow stored procedures after migration 2008 to 2016 SQL server

  Dear, i have recently migrated database from SQL 2008R2 SP3 (WS 200R2 )to SQL2016 SP2 CU2 (WS 2012R…

  alexandermkd

  23 replies

  6 years, 11 months ago

  By: Jeff Moden

• Recommendations for "phasing out" of local SQL backups for NetApp SNAPS

  We're having a debate regarding administration of SQL server backups. Recently we've started u…

  Toddmonster85

  3 replies

  6 years, 11 months ago

  By: Jeff Moden

• Availability Groups and SQL Server 2016 Failover Cluster

  Hi, I have 3 Windows Failover Cluster nodes in a cluster. Node1 and Node2 is in the same data cente…

  LGDBA

  1 replies

  6 years, 11 months ago

  By: Steve Jones - SSC Editor

• Licensing AOAG

  Hi, A 3 node Always on Availability Group NODE 1 . OLTPNode 2.   REPORTINGNODE 3  DR…

  Super Cat

  1 replies

  6 years, 11 months ago

  By: Steve Jones - SSC Editor

• Log file and data file growth

  Hi Gurus,Is there anyway to query to see if log or/and data file growing NOT the auto growth (I can…

  Tac11

  7 replies

  6 years, 11 months ago

  By: Jeff Moden

• Managing logins and permissions

  Hi We are currently cleaning up the logins and access in our instances. Currently, it is a mix of i…

  donut

  1 replies

  6 years, 11 months ago

  By: Michael L John

• Query Store not collecting?

  Ive got a 2016 instance with Query Store enabled on it. its in Read_Write requested and actual mode…

  LAW1143

  4 replies

  6 years, 11 months ago

  By: LAW1143

• Database in RECOVERY PENDING state - Access Denied

  HiI have s SQL2016 instance with 8 out of 10 databases in recovery pending state and I need assista…

  angelinemarren

  13 replies

  6 years, 11 months ago

  By: prettsons