Administration - SQL Server 2014

• Topics

  Started by

  Posts

  Last post

• AlwaysOn Secondary backup (Full & Log) - Primary T-Log not shrinking

  Hi All,We recently changed to AlwaysOn, running SQL Server 2012, 2014 and 2016 clusters in AlwaysOn…

  Roger Mac

  17 replies

  8 years, 9 months ago

  By: Roger Mac

• Login failed for user 'joebloggsSQL@domainname.internal' Reason: Could not find a login matching the name provided

  Hi  I am receiving this error message when a user tries to login: Login failed for user 'joebl…

  caz100

  3 replies

  8 years, 9 months ago

  By: Thom A

• HELP Pls!!! ->Best pratice for SQL SERVER with SSD *10(400GB) & SAS 10k*6(600GB)

  I need your help for setting disk for sql server I used this machine for gamedb . My server detail…

  MaggY

  1 replies

  8 years, 9 months ago

  By: Perry Whittle

• Need to rebuild Index on 1.4 TB table (Replication is setup on that database) and also on 900 GB table(mirroring is setup on database

  Hello, I need to rebuild Index on below Huge tables for our two databases 1. 1.4 TB table ( Replica…

  kiran_Sqldba

  10 replies

  8 years, 9 months ago

  By: Jeff Moden

• SQL Server Cluster Licence Question

  Hello All, I am looking at SQL Server Clustering for a new client. We want to look at providing a C…

  Tjbillybob

  3 replies

  8 years, 9 months ago

  By: FridayNightGiant

• PKI/certificates to authenticate to SQL Server

  Hello,at start sorry for perhaps dumb question but im kinda new to pki/certificates subject in term…

  lavertan

  1 replies

  8 years, 9 months ago

  By: Steve Jones - SSC Editor

• Removing Cluster Disk

  We have a two node cluster and we recently added a 1TB cluster disk and joined it to SQL Server. St…

  Rechana Rajan

  3 replies

  8 years, 9 months ago

  By: Perry Whittle

• Transaction Logs

  Hello. I have  lot of DBs that have very large transaction Log files and some have a huge numb…

  SteveOC

  3 replies

  8 years, 9 months ago

  By: rvsc48

• Plan generation differs one databases

  My SP's plan generation differs on two sets of databases having same schema.One of the db is l…

  khushbu

  1 replies

  8 years, 9 months ago

  By: Ant-Green

• Arithmetic overflow error converting IDENTITY to data type int - int to bigint questions

  Hi, I recieved this error: Arithmetic overflow error converting IDENTITY to data type int I believe…

  krypto69

  1 replies

  8 years, 9 months ago

  By: Ant-Green

• Server Side SSL SQL Network Encryption - selfsign cert - why is it working ?

  Hi all, In BO, it is emphasize that using self-sign cert promotes MITM attacks and we should use CA…

  szejiekoh

  4 replies

  8 years, 9 months ago

  By: Ed Wagner

• High Memory consuming by Database

  Hello Everyone, I have a database which size is 250 GB and it contains the information about 70 Lak…

  amitsingh308

  12 replies

  8 years, 9 months ago

  By: Gail Shaw

• Error in Trigger

  I'm trying to devise a way to run a PowerShell script from a job when changes are made to  pro…

  lmarkum

  5 replies

  8 years, 9 months ago

  By: lmarkum

• Authentication KERBEROS and NTLM

  I have 2 SQL Server 2014 databases on 2 servers DB1 = auth_scheme KERBEROSDB2 = auth_scheme NTLM I …

  prestowd-sql

  7 replies

  8 years, 9 months ago

  By: Mr. Brian Gale

• Log Shipping Instance TempDB Allocation

  We have log shipping instance setup, should the log shipping instance have the same number of tempd…

  LOOKUP_BI-756009

  4 replies

  8 years, 9 months ago

  By: Arsh