SQL Server 2016 - Administration

• Topics

  Started by

  Posts

  Last post

• Using EE to trace the code generated by an app

  Hi all, We have an app that currently requires Admins /Power users to navigate a difficult GUI, but…

  JaybeeSQL

  3 replies

  3 years, 9 months ago

  By: Mr. Brian Gale

• External process holding the log and SQL give 'Unable to cycle error log'...

  Hello We have a servers with the following issue Msg 17049, Level 16, State 1, Procedure sp_cycle_e…

  Angel_V

  5 replies

  3 years, 9 months ago

  By: Angel_V

• Always On and Read-Intent-Only secondarys

  Hi Doing some testing on a server that has 2 node AG setup. Secondary is set to Read-Intent-only. W…

  PearlJammer1

  3 replies

  3 years, 9 months ago

  By: Jeffrey Williams

• Restore Database with RECOVER generates new values for identity columns

  Hi, We have restored the production backup to a different machine for testing purposes. We found th…

  Abdullah_Madani

  15 replies

  3 years, 9 months ago

  By: oogibah

• DBCC Checkdb cannot finish - Msg 8921, Level 16, State 1, Line 8 Check terminate

  Hello We have this issue on one of our Prod databases. The database is fully operational but our DB…

  Angel_V

  3 replies

  3 years, 9 months ago

  By: Mr. Brian Gale

• SQL Server and CloudStrike

  Has anyone had issues with CloudStrike Anti-Virus on their SQL Servers? I've had a client install C…

  Leo.Miller

  1 replies

  3 years, 9 months ago

  By: Ant-Green

• Cannot create SQL AG Listener

  HI i am getting this error when i am creating the listener in my AG Cluster resource of type 'Netwo…

  hpatel

  3 replies

  3 years, 9 months ago

  By: EdVassie

• Replication and Deadlocks at subscriber

  Hello friends, and happy TurkeyDay, I have a database used for reporting, a subscriber, that occasi…

  MiguelSQL

  4 replies

  3 years, 9 months ago

  By: Mr. Brian Gale

• Linked Server (to ODBC) connection test times out, test of ODBC is successful

  We have a scheduled job that utilizes a Linked Server connection that is simply referencing an ODBC…

  sgt1190

  1 replies

  3 years, 9 months ago

  By: sgt1190

• The process could not execute sp_repldone/sp_replcounters

  Hi All, From the replication log agent , we get this error message "the process could not execute s…

  WhiteLotus

  2 replies

  3 years, 9 months ago

  By: Mr. Brian Gale

• DR test - failover with potential data loss on live server.

  Hi All, So I want to test failover to my DR site.  My current set up is 2 x replica in site A (sync…

  snomadj

  4 replies

  3 years, 9 months ago

  By: snomadj

• alter partition function

  Hello, I have a DB with partitions create partition function PF_IdEmpresas (smallint) AS range left…

  msimone

  2 replies

  3 years, 9 months ago

  By: msimone

• Turning Clustered index into PK without creating additional index?

    Adding PK to existing table like in the below example with existing Clustered index automati…

  VoldemarG

  7 replies

  3 years, 10 months ago

  By: Michael L John

• Alter default SQL generated in context menu top 1000

  Hi All. When the context menu is bought up on a database table after clicking the right mouse butto…

  ChrisVeale

  4 replies

  3 years, 10 months ago

  By: ChrisVeale

• Restore Backup issue having filestream filegroup

  Below Script is getting failed ;RESTORE DATABASE [NTAFSDB] FROM DISK = 'D:\backup-NTA\NTAFSDB.bak' …

  Bhuvnesh

  1 replies

  3 years, 10 months ago

  By: Ant-Green