Administration - SQL Server 2014

• Topics

  Started by

  Posts

  Last post

• Replace Primary Server keeping same Log Shipping Server

  I have a two node SQL Standard 2014 Failover Cluster at the primary site.  It does Log Shipping ov…

  BobAtDBS

  1 replies

  1 year, 9 months ago

  By: BobAtDBS

• TempDb on Drive Root

  Does anyone know of any documentation that supports the placement of Tempdb files on the root of a …

  manguml

  8 replies

  1 year, 11 months ago

  By: JohnBevan

• Parallel Execution Plan - Or not.

  Hello. SQL Server 2014 - 3 Numa Nodes - 6 processors in each Numa Node (not that is not the issue) …

  SteveOC

  6 replies

  1 year, 11 months ago

  By: EdVassie

• Error on File

  Hi Experts, I have a database with multiple files on multiple drives and one of the drive is restri…

  VastSQL

  2 replies

  1 year, 11 months ago

  By: Jeffrey Williams

• how to check the table is being used(selecting/inserting/updating/deleting/locki

  how to check the table is being used(selecting/inserting/updating/deleting/locking) by some sql sta…

  892717952

  2 replies

  1 year, 11 months ago

  By: Jeff Moden

• Rectify Error

  Hi Experts, How can I rectify the below error in SQL Agent log. [298] SQLServer Error: 805, SSL Pro…

  VastSQL

  3 replies

  1 year, 11 months ago

  By: Grant Fritchey

• how to keep two databases with different collation on one instence

  hi, i want to keep two databses with diffrent collation on one instence of sqlserver but following …

  rajemessage 14195

  4 replies

  1 year, 11 months ago

  By: frederico_fonseca

• db_datareader user cannot connect to read-only routed AlwaysOn SQL cluster

  I have set up a 2-node SQL AlwaysOn cluster and configured read-only routing for requests to be ans…

  goftari

  2 replies

  1 year, 11 months ago

  By: goftari

• Replacing Physical Server

  Hi We are going to update our old SQL physical servers to brand new machines. In the planning in my…

  krypto69

  7 replies

  1 year, 11 months ago

  By: EdVassie

• DB in Recovery Pending

  Hi Guys/Gals I thought I'd just come straight to the experts. I have a important DB in a Recovery P…

  SQL Bandit

  11 replies

  1 year, 12 months ago

  By: Techno-Umesh

• Windows Account getting wrong SID when added to SQL Server

  I have a truly odd one and wonder if anyone else has even seen this. I have a situation where multi…

  Stamey

  6 replies

  2 years ago

  By: Stamey

• Saving transaction backup logs off the DB server

  Hi everyone, I would appreciate your comments/suggestions/points on the following question. Please …

  jellybean

  11 replies

  2 years ago

  By: jellybean

• Mirroring transport endpoint error:8474

  I see several posts regarding this error. I feel I don’t need to stop and start the endpoint. We …

  ramana3327

  1 replies

  2 years, 1 month ago

  By: ramana3327

• Probleme With Access to Reporting Services SSRS

  Hi I have a problem when i try tio display Report, (Win Server 2008R2 And SQL 2014 ) i can access o…

  atsushi

  2 replies

  2 years, 1 month ago

  By: KWood9457

• Get ID from Analysis Server cube.

  I am fixing an issue with our automated Analysis Server backups. We use SELECT * FROM $SYSTEM.DBSCH…

  Leonard Rutkowski

  2 replies

  2 years, 1 month ago

  By: KWood9457