SQL Server 2016 - Administration

• Topics

  Started by

  Posts

  Last post

• Error while configuring replication on top of AG in SQL server 2016

  All Pub dist and Sub servers are in AG with Sql server 2016 SP3 version and while configuring repli…

  prem.m38

  3 replies

  1 year, 4 months ago

  By: CreateIndexNonclustered

• Suppress Backup Messages In Logs

  I'm trying to get rid of all backup messages in my SQL logs and I was able to successfully suppress…

  RonMexico

  8 replies

  1 year, 4 months ago

  By: Tuan Nguyen

• Continuous lock timeout when trying to exec sp_configure

  Hello experts, I'm seeing a strange issue. Yesterday I noticed that I was getting this error when I…

  webrunner

  4 replies

  1 year, 4 months ago

  By: cyrusbaratt

• Need to read ErrorLog to get the END TIME of last restore?

  is there a stored proc somewhere for sql server 2016 that can return latest restore database durati…

  VoldemarG

  7 replies

  1 year, 4 months ago

  By: VoldemarG

• Date when User was added to server-level role

  How to get (if possible) date when Login was added to any server-level role? Like temporarily- to s…

  Yuri55

  5 replies

  1 year, 4 months ago

  By: Yuri55

• SQL Mirroring with Witness - Workgroup joined computers

  Hi, I am trying to configure mirroring an some old 2016 SQL servers for a client. The PCs have full…

  jszatkowski3

  1 replies

  1 year, 5 months ago

  By: jszatkowski3

• Database copy issue through - COPY DB WIZARD

  I have a production server with SQL server 2016 version (13.0.5026.0) and a database with 25 GB of …

  Kaushik Parui

  10 replies

  1 year, 5 months ago

  By: Andy sql

• System versioned tables permissions

  I have an issue with these permissions which I don't understand. When I add a user to a database co…

  as_1234

  9 replies

  1 year, 5 months ago

  By: as_1234

• Always encryption error

  Hi All, Seeking out help on SQL 2016 Alwayson feature. One of the tables in Always encrypted. When…

  vsamantha35

  4 replies

  1 year, 5 months ago

  By: SQlLogic

• Failed to initialize the Common Language Runtime (CLR) v4.0.30319 with HRESULT 0

  Hi All Hope you can help me with this one as we are pulling our hair out. So a few weeks back we en…

  craigashields

  2 replies

  1 year, 6 months ago

  By: Sparky

• How to view actual execution plan, for long running jobs?

  I have a couple of very long running jobs which are scheduled by SQL Agent. These jobs are doing ar…

  JasonO

  2 replies

  1 year, 6 months ago

  By: Grant Fritchey

• Index Creation for large table failed.

  I'm trying to create a clustered index on a very large heap table. Below is the script i'm using to…

  JasonO

  4 replies

  1 year, 6 months ago

  By: JasonO

• Always ON, HA, File Location Problem

  Hello All, I have four VMs setup while I am learning SQL Server Admin tasks and configurations.  S…

  mjdemaris

  7 replies

  1 year, 6 months ago

  By: Jeffrey Williams

• Monthly Partitioning issue a number of months missed

  I've joined a new company and have noticed that a scheduled partition creation job hasnt been runni…

  Vets5

  2 replies

  1 year, 6 months ago

  By: Vets5

• Index

  I have Index Maintenance Job I have stand alone secondary server when I run on secondary server it …

  Nita Reddy

  7 replies

  1 year, 7 months ago

  By: Michael L John