SQL Server 2019 - Administration

• Topics

  Started by

  Posts

  Last post

• Registered Servers

  From the server which is registered as a Central management server(CMS)  can I create a SQL job(aut…

  mtz676

  6 replies

  1 year, 11 months ago

  By: Ant-Green

• Event ID 17806

  We have had SSPI errors across a dozen servers in an hour span. https://bobcares.com/blog/sql-error…

  mtz676

  4 replies

  2 years ago

  By: andreas.kreuzberg

• Move DB

  Hi everyone My SSD is starting to fill up so I am looking at buying a new drive and moving the DB i…

  water490

  13 replies

  2 years ago

  By: Jonathan AC Roberts

• Replication - Changing Publisher Database While Maintaining Subscriber

  I am replicating some ERP tables to another instance of SQL on a separate VM.  Replication on the E…

  redruMKills

  1 replies

  2 years ago

  By: redruMKills

• Logon failure: the user has not been granted the requested logon type at this co

  Hi, I have installed Report Server on two Windows Server 2019 machines. I believe I have followed t…

  Kevins1966

  2 replies

  2 years ago

  By: frederico_fonseca

• File group size issues

  Error: Could not allocate space for object because filegroup is full. dbName FileName type_desc    …

  mtz676

  21 replies

  2 years ago

  By: mtz676

• Backup procedure not reading last modified date

  I have a VBScript file fired from a Windows scheduled task calling a stored procedure. The procedur…

  pdanes

  27 replies

  2 years ago

  By: CreateIndexNonclustered

• Migrate SSIS packages from SQL 2005 to SQL 2022

  Hi All, is it possible to migrate SSIS packages from SQL 2005 to SQL 2022. All of our SSIS packages…

  Saran

  6 replies

  2 years ago

  By: Saran

• Semaphore/DNS Issues Connecting to Failover Cluster

  Hello - over the last few months we have been receiving Semaphore Timeout errors connecting to our …

  DjH

  1 replies

  2 years ago

  By: DjH

• AKV with Always Encrypted for applications on premise

  Hello! I would like to have any feedback on using AKV to store and manage a column master key for A…

  sqlvesna

  3 replies

  2 years ago

  By: Mr. Brian Gale

• RAM on the SQL Instance

  Hi everybody, I have a 500 GB highly transactional database on the SQL 2019 Enterprise instance, ru…

  AER

  7 replies

  2 years ago

  By: CreateIndexNonclustered

• delete or truncate i a script don't work?!?

  i want to backup a sql database and restore this database to new name. this works fine. so i have o…

  christophhennef

  1 replies

  2 years ago

  By: Mr. Brian Gale

• SQL serve migration DMA result suggestion?

  Hi All, I am planning to migrate SQL server from old to new server and run the DMA found some Break…

  Saran

  3 replies

  2 years ago

  By: Saran

• Increase the MaxTokenSize value of the server computer

  The prelogin packet used to open the connection is structurally invalid; the connection has been cl…

  mtz676

  5 replies

  2 years ago

  By: mtz676

• AD permissions updates CVE-2021-42291 and AO Clusters/GL

  I have an SQLSERVER Always on Environment. In AD it's logging:  The directory service detected an L…

  Shelley Allen

  3 replies

  2 years ago

  By: Shelley Allen