SQL Server 2019 - Administration

• Topics

  Started by

  Posts

  Last post

• CPU Pressure.

  Good morning! I'm seeing CPU pressure on my SQL VMs - 4 node cluster, 20 CPU Intel Xeon 2.2GHz, 128…

  jessymcjessface

  9 replies

  2 years ago

  By: Michael L John

• disable seeding mode

  hello , On one of our servers with 4 Replicas 2 synchronous and 2 asynchronous we see too many wait…

  abdalah.mehdoini

  1 replies

  2 years ago

  By: Johan Bijnens

• SQLPackage Import Error

  Hi After 1h the import fails with the error: Error SQL72014: Core Microsoft SqlClient Data Provider…

  JanM-66

  2 replies

  2 years ago

  By: JanM-66

• logical consistency-based I/O error for tempdb.ndf

  Event 824 from event viewer. Recommendation: Complete a full database consistency check (DBCC CHECK…

  mtz676

  10 replies

  2 years ago

  By: Grant Fritchey

• Securing access to SQL Instance

  Hi, I have a need to harden-down users access to a SQL Server instance. I have a number of SQL auth…

  Duncan Lawrence

  4 replies

  2 years ago

  By: Jeffrey Williams

• Can I set the publisher database into read-only mode

  Hi - Can you set the db into read-only mode if it’s part of replication. As part of migration, I ne…

  SQLisAwe5oMe

  2 replies

  2 years ago

  By: SQLisAwe5oMe

• ALTER or DROP TABLE could not clean up root row within 10 seconds

  We keep getting these errors quite frequently. How do we troubleshoot and fix these errors ? Are th…

  mtz676

  4 replies

  2 years ago

  By: Steve Jones - SSC Editor

• msdb job history permission error

  SELECT * FROM msdb.dbo.sysjobhistory error: The SELECT permission was denied on the object 'sys…

  lan2022nguyen

  2 replies

  2 years ago

  By: lan2022nguyen

• Check AAG is the primary before running a SQL Agent job

  Hi All, I am trying to setup SQL so that if the primary becomes the secondary, the SQL agent will c…

  Kris-155042

  11 replies

  2 years ago

  By: Kris-155042

• Query joins and SQL Server mirroring (2019)

  Have a bit of a situation with database mirroring and table joins, hopefully someone can shed some …

  savage_ZA

  2 replies

  2 years ago

  By: Eddie Wuerch

• How to Backup SQL Active/Passive cluster Database to File Share

  Hi We have 2 node Active/Passive SQL serer cluster with 2 databases, due to the backup disk capacit…

  Harshana-455711

  2 replies

  2 years ago

  By: Harshana-455711

• Color Particular Column

  Hi I want to color particular column . If value is -ve then color should be red Thanks

  jagjitsingh

  5 replies

  2 years ago

  By: Jeff Moden

• AOAG resources partially disappearing

  Dear all, I am posting here as I have been struggling 3 days now on an issue and am looking for gui…

  Marko

  2 replies

  2 years ago

  By: Marko

• Maintenance Plan folder missing under Management folder in SSMS

  Im logged in with a sysadmin account. The edition is 2019 SQL Server Developer Edition. I feel like…

  koln

  2 replies

  2 years ago

  By: koln

• Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.

  Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'. Reason: Could not find a login matching the n…

  lan2022nguyen

  2 replies

  2 years ago

  By: rothj