SQL Server 2016 - Administration

• Topics

  Started by

  Posts

  Last post

• SQL Server Always On Availability Group Lab Setup

  Hi, I wanted to setup/practice Availability Groups( Refer to the below link article) at my own lab …

  sizal0234

  3 replies

  4 years, 11 months ago

  By: sizal0234

• Simple Recovery Model - Active VLFs cannot be truncated

  Hi everyone, I am facing a strange situation. I've got 99% of VLFs active and ckeckpoint is not wo…

  jdlayton83

  6 replies

  4 years, 11 months ago

  By: tmisganaw

• Performance and usage of system stored procedure sp_columns_100

  Hello experts, I'm researching different ways to monitor SQL Server CPU usage by query. I know ther…

  webrunner

  3 replies

  4 years, 11 months ago

  By: webrunner

• Error connecting to sql using listener name only

    Hello I've a problem when i try to connect to an instance with Always On When i use a domain…

  luce

  12 replies

  4 years, 11 months ago

  By: Johan Bijnens

• SQL server night cpu usage

  Hi using MS SQL maintenance plan to update statistic with full scan. The plan running over 2 days b…

  shan201907

  1 replies

  4 years, 12 months ago

  By: Grant Fritchey

• SQL permissions based on multiple AD Groups

  Hi I'd like some input on the best way to handle setting permissions in SQL Server 2016 using 2 Act…

  pfranks 18140

  5 replies

  4 years, 12 months ago

  By: Ant-Green

• Mirroring Automatic Failover?..

  Hello, We are receiving the below Error message in Mirroring and principal server is failovering au…

  alexsunny123

  4 replies

  4 years, 12 months ago

  By: alexsunny123

• Backup time not reducing even after DB size went down 300 GB

  Backup time is almost same and did not reduce after the database size went down by 300 GB. What cou…

  PJ_SQL

  22 replies

  4 years, 12 months ago

  By: Michael L John

• error while running Replication

  Has anyone faced this error Agent message code 20037. The process could not bulk copy into table '"…

  atulyan.aries

  1 replies

  5 years ago

  By: Michael L John

• How to reduce physical size of database

  I deleted few tables having millions of records, but when see the physical space, itt has not reduc…

  coolchaitu

  12 replies

  5 years ago

  By: Johan Bijnens

• Replication sending same change over and again when doing a batch update

  Good morning, I recently set up replication on my sql server - Microsoft SQL Server 2016 (SP2) (KB4…

  duncanburtenshaw

  3 replies

  5 years ago

  By: duncanburtenshaw

• Replaced deprecated types (text, ntext) with Varchar(max) and NVarchar(max) !

  in 500 tables, on thousands of columns in all databases on entire server, I have replaced deprecate…

  VoldemarG

  5 replies

  5 years ago

  By: Jeff Moden

• NOT able to backup database

  Hello All, Facing a problem backing up a database. When i click on backup database in the select ba…

  akashi

  4 replies

  5 years ago

  By: Jeff Moden

• Database Mail - Not sending mail

  Hi there,I have been attempting to troubleshoot my issue with email not being sent from the se…

  cs_source

  4 replies

  5 years ago

  By: Singhka

• Sql error log

  We have job which is configured to recycle the sql error log on daily basis and its failing with th…

  ramyours2003

  5 replies

  5 years ago

  By: ScottPletcher