SQL Server 2016 - Administration

• Topics

  Started by

  Posts

  Last post

• 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

  1 hour, 39 minutes 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

  1 day, 3 hours ago

  By: Mr. Brian Gale

• 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

  2 replies

  1 day, 16 hours ago

  By: andreas.kreuzberg

• Replication and Deadlocks at subscriber

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

  MiguelSQL

  2 replies

  2 days, 4 hours 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 (syn…

  snomadj

  4 replies

  3 days, 12 hours ago

  By: snomadj

• 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

  3 replies

  5 days, 7 hours ago

  By: Michael L John

• alter partition function

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

  msimone

  2 replies

  5 days, 10 hours 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…

  Vladimir Isaev

  7 replies

  1 week, 3 days ago

  By: Michael L John

• 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

  1 replies

  1 week, 4 days ago

  By: Mr. Brian Gale

• 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

  1 week, 5 days 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

  2 weeks ago

  By: Ant-Green

• TLS 1.2 communication problem

  I'm trying to get 2 servers to communicate using TLS 1.2. On the calling web sever I have disabled …

  pds000

  3 replies

  2 weeks, 1 day ago

  By: rlDawson_SLC

• DB and VM backup timing

  Hello experts, In terms of backups, we have database backups set up, which I am familiar with, but …

  webrunner

  3 replies

  2 weeks, 1 day ago

  By: andreas.kreuzberg

• New Index Maintenance Methods Recommended by Microsoft

  With reference to the following MS article... https://docs.microsoft.com/en-us/sql/relational-datab…

  Jeff Moden

  45 replies

  2 weeks, 4 days ago

  By: Jeff Moden

• Query to fetch top SQL statements

  Hi All, Please help me in getting the below information. I prefer T-SQL statements over GUI dashboa…

  Abdullah_Madani

  10 replies

  3 weeks ago

  By: Jeff Moden