SQL Server 2019 - Administration

• Topics

  Started by

  Posts

  Last post

• error -SQLVDI: Loc=SignalAbort. Desc=Client initiates abort. ErrorCode=(0). Proc

  Hello experts,   Recently we have migrated sql 2012 to 2019 post migration Az VM  while runnin…

  jamessdba

  1 replies

  1 year, 2 months ago

  By: jamessdba

• SQL SSRS license info

  hello,   i am trying to find where SSRS edition and product key information are stored in SSRS…

  mxy

  1 replies

  1 year, 2 months ago

  By: mxy

• LinkedServer error

  I getting the bellow error when runing query on linkedserver from another server after adding linke…

  Yousaf Khan

  2 replies

  1 year, 2 months ago

  By: Mr. Brian Gale

• Run SSIS package asynchronously from SQL Agent job step

  I'd like to run an SSIS package asynchronously from a SQL Agent job step through the the [SSISDB].[…

  Pete Bishop

  10 replies

  1 year, 3 months ago

  By: Pete Bishop

• RESERVED_MEMORY_ALLOCATION_EXT wait and totally slowness

  Hi, we have a little bit of an interesting topic. Sometimes, we get wait RESERVED_MEMORY_ALLOCATION…

  tony28

  3 replies

  1 year, 3 months ago

  By: tony28

• sysmail_event_log last_mod_user has a disabled login

  Hello experts, We routinely disable sa after a SQL install. However, while troubleshooting a databa…

  webrunner

  2 replies

  1 year, 3 months ago

  By: andreas.kreuzberg

• SQLCMD and the permissions needed

  Hey all, Hopefully this is a simple question. I am trying to figure out what permissions are needed…

  chapwolff

  1 replies

  1 year, 3 months ago

  By: frederico_fonseca

• Swapping ports between 2 instances - can't understand results

  Have 2 instances on the same TestServer 1. Default 2014 Dev edition on port 1433 2. Named 2019 Expr…

  terry999

  1 replies

  1 year, 3 months ago

  By: terry999

• ghost backups processed 0 pages

  I've got something I'm not aware of performing backups of my dbs at random times in the day. I thin…

  Snargables

  6 replies

  1 year, 3 months ago

  By: Perry Whittle

• DBNETLIB] [ConnectionOpen (SECDoClientHandshake()).] SSL Security Error

  Hi New server with SQL version 2019 has been created to host a DB for a Legacy App to use.  This is…

  terry999

  3 replies

  1 year, 3 months ago

  By: Perry Whittle

• SQL JOB add/modified

  Is there a trigger to notify when a new SQL Agent job is created/modified?

  Shelley Allen

  4 replies

  1 year, 3 months ago

  By: Jeff Moden

• Extend Event with sqlserver.login

  My knowledge of Extended Events is limited, but I am trying to capture some login details with exte…

  Ken McKelvey

  5 replies

  1 year, 4 months ago

  By: Perry Whittle

• The OS returned the error '(null)' while attempting 'DeleteFile' filestream.hdr

  I have a SQL Server 2019 Enterprise Edition on CU 25. It has in-memory oltp enabled. I have a full …

  lmarkum

  4 replies

  1 year, 4 months ago

  By: Perry Whittle

• Backing up and Restoring a 3 terabyte database takes over 5 hours

  I have a 3 terabyte database that is taking over 5 hours to backup and restore. I'm utilizing multi…

  ericwenger1

  6 replies

  1 year, 4 months ago

  By: TL

• can I monitor auto stats updates through extended events?

  We have pretty big tables very sensitive to stats with many updates. Our systems are complex with m…

  Eric Mamet

  2 replies

  1 year, 4 months ago

  By: Grant Fritchey