SQL Server 2019 - Administration

• Topics

  Started by

  Posts

  Last post

• Somebody realized to configure Cluster-Aware updating on VMWare nodes

  Creating an Windows Server Fail-over Clusters with two SQL server 2022 and a File server. All serve…

  boskabouter 007

  2 replies

  5 months, 1 week ago

  By: boskabouter 007

• SSIS Won't Create Log Entries

  Hi everyone My SSIS package will not log to sysssislog.  I am not sure what to do to troubleshoot. …

  water490

  4 replies

  5 months, 3 weeks ago

  By: water490

• SQL Server is terminating in response to a 'stop' request from Service error

  Dear All, In one of the server its repeatedly restarting sqlserver services and not found any thing…

  naga.rohitkumar

  3 replies

  5 months, 3 weeks ago

  By: rothj

• Size of DB on physical disk doesn't match Disk Usage by Table report

  Hi everyone I am looking at the size of my db on disk (ie c-drive) and comparing it against SS repo…

  water490

  7 replies

  5 months, 3 weeks ago

  By: Ant-Green

• Installing SQL Instance on a Clustered Virtual Disk

  Hi Everyone, I have a question, I am trying to setup a Lab environment with 1 DC and 2 SQL Nodes , …

  bokswager

  4 replies

  5 months, 4 weeks ago

  By: WirkKarl

• Error - Invalid Number when i use String_Agg

  Hi Select T1."transType", WHEN T1."TransType" = '46' THEN (SELECT STRING_AGG (A0."LocCode", ',') fr…

  jagjitsingh

  1 replies

  6 months ago

  By: jagjitsingh

• Distinct values using string_agg

  Hi Is it possible to get distinct values using string_agg Select T1."transType", WHEN T1."TransType…

  jagjitsingh

  1 replies

  6 months ago

  By: frederico_fonseca

• Migration related issue

  I migrated DB server from 2017 enterprise to 2019 enterprise. After the migration, every setting on…

  LearningDBA

  7 replies

  6 months ago

  By: Grant Fritchey

• How to backup a specific table to an external folder?

  Hi everyone My SS db has a bunch of tables that I don't use.  I would like to archive them outside …

  water490

  5 replies

  6 months, 1 week ago

  By: Ken McKelvey

• Running DML on a Primary AG Instance

  Kind of a DML question - but specific to an AG instance running on SQL Server 2019 - so starting he…

  SteveOC

  1 replies

  6 months, 1 week ago

  By: SteveOC

• ExecutionLog3 table in Reportserver Database

  I have a SSRS report for which users are complaining to be slow, but from querystore, I can see tha…

  SqlAdmin001

  3 replies

  6 months, 1 week ago

  By: Tav29

• SQL Server Maintenance Plan Feedback

  Hi I set this up today.  I wanted to get some feedback.  I have some questions: 1. How often should…

  water490

  3 replies

  6 months, 2 weeks ago

  By: water490

• SQL Server Migration - Redirecting Old Instance Connections to New AG Listener

  Hi everyone, I’ve been tasked with migrating a Standalone SQL Server instance to a highly available…

  Wecks

  3 replies

  6 months, 3 weeks ago

  By: EdVassie

• Error when trying to enable cdc . Could not update the metadata

  Server and db in SQL SERVER 2019. I have multiple tables that are enabled for CDC , however startin…

  pamkagel

  3 replies

  6 months, 3 weeks ago

  By: Ant-Green

• Server Role for User Database Access

  I am looking to simplify a development server access issue.  Databases are constantly being added t…

  dpaskiet

  3 replies

  7 months ago

  By: Jeffrew