Administration - SQL Server 2014

• Topics

  Started by

  Posts

  Last post

• Duplicated post, please delete

  I am running SQL2012 (don't ask...) and my collation is Latin1_General_CI_AS and my language code i…

  aaron.reese

  1 replies

  11 months, 2 weeks ago

  By: Phil Parkin

• Changing Encryption on database from triple des to aes

  We currently have a Windows 2016 server running Sql Server 2014 that uses triple des for field encr…

  northplatteriver

  5 replies

  11 months, 3 weeks ago

  By: Steve Jones - SSC Editor

• SQL server disk block size formatted as 4KB runs slow

  Hello All, One of my SQL server 2014 all the disk are formatted as 4KB. I see Microsoft recommends …

  Saran

  9 replies

  11 months, 3 weeks ago

  By: Ant-Green

• Replication Reinitialization from backup

  I have Reinitialization transactional replication of 950 GB database from backup. It is working fin…

  Saran

  2 replies

  11 months, 4 weeks ago

  By: Saran

• Strange Deadlock Graph showing multiple DB but isolated

  Hi Experts, I am observing strange deadlock behaviour where one deadlock graph have 2 isolated data…

  VastSQL

  15 replies

  1 year ago

  By: Mr. Brian Gale

• Data Archiving

  Hi All Our company is planning to archive historical data from production database which has 15+ ye…

  Barcelona10

  7 replies

  1 year ago

  By: eric_shane

• migrating to the latest version of sql server

  Hello everyone, We have several SQL Server 2014 instances with databases ranging from 3 to 8 teraby…

  m.azizi

  4 replies

  1 year, 1 month ago

  By: Eirikur Eiriksson

• DB with MDF and multiple NDFs vs a single large MDF - all on same Logical Drive.

  Hello. We have a couple of databases, that were novated as part of an acquisition, that have multip…

  SteveOC

  11 replies

  1 year, 2 months ago

  By: Jeff Moden

• Error: 18056, Severity: 20, State: 29.

  Error: The client was unable to reuse a session with SPID 554, which had been reset for connection …

  kvishu83

  4 replies

  1 year, 2 months ago

  By: siavash.golchoobian

• FTS Catalogs Set to Case Sensitive True/False

  I understand what the setting means for Collation Sequences and the impact it has on Indexes and in…

  SteveOC

  1 replies

  1 year, 2 months ago

  By: Site Owners

• FTS Not enabled for DB - but it is working(?)

  Hello. I have a couple of DBs that say that Full Text Search is not Enabled on the DB - yet it seem…

  SteveOC

  2 replies

  1 year, 2 months ago

  By: SteveOC

• Suggestion on HA DR solution for transactional replication published database

  Hi All, I am planning for HA DR solution for transactional replication published database. (Not for…

  Saran

  6 replies

  1 year, 3 months ago

  By: Saran

• How to include newly system generated tables to SQL replication?

  Hi there, I have this situation that I have been trying to get around for some time but I haven't b…

  RegzP

  3 replies

  1 year, 3 months ago

  By: RegzP

• Replication subscription says inactive

  Hi All, I am new to replication, one of my replication subscription says inactive. I just got hando…

  Saran

  1 replies

  1 year, 4 months ago

  By: Saran

• Newly created login can not see/connect to user database

  Hi guys I have 2014 sql server that has 4 logins. These logins can connect to user databases that t…

  Barcelona10

  16 replies

  1 year, 4 months ago

  By: Jeff Moden