Administration - SQL Server 2014

• Topics

  Started by

  Posts

  Last post

• TCP Timeout error 258 after Firewall chnage

  Hi All, We are getting timeout errors from app servers after a firewall change was made. Please sha…

  SQL!$@w$0ME

  2 replies

  10 years, 6 months ago

  By: SQL!$@w$0ME

• Responsibilities of L1-DBA

  Hello sir, i'm Raja.. I've opening on L1- DBA.... So I want to know about the " Responsibilities o…

  eluriraja

  4 replies

  10 years, 6 months ago

  By: Jeff Moden

• Replication with Always On Availability Groups - some questions

  Hi all, We're about to setup our first Windows Cluster with Always On Availability Groups, and I ha…

  samalex

  2 replies

  10 years, 6 months ago

  By: nick.winstanley

• Planned and scheduled failover

  Hi everyone, I am looking for a solution to bypass our company policy to automatically reboot a ser…

  pnx81

  2 replies

  10 years, 6 months ago

  By: pnx81

• Identify the queries that are using the most space in tempdb / Export tempdb table data?

  We have SQL Server 2014 EE SP1 running on Windows Server 2012 R2 Standard O/S. First Item: I had a…

  HookSQLDBA7

  1 replies

  10 years, 6 months ago

  By: SoHelpMeCodd

• SQL monitoring Tools - System Center 2012 R2

  Hi - I'm exploring different tools to monitor our global SQL environment. Currently, I use Confio (…

  cheshirefox

  3 replies

  10 years, 6 months ago

  By: curious_sqldba

• Scheduled backup 2014 exp

  I'm using SQL server 2014 express. I'm now trying to shedule a backup. I'm using an maintenance acc…

  DubbySwords

  6 replies

  10 years, 6 months ago

  By: Johan Bijnens

• Unsafe assembly 'microsoft.sqlserver.integrationservices.server, version=12.0.0.0

  We're running SQL Server 2014 Enterprise edition (12.0.4100 x64) on Windows Server 2012 R2 Data Cen…

  Express12

  1 replies

  10 years, 6 months ago

  By: SoHelpMeCodd

• Improve sql server logs

  I want to improve logs which stores in default trace by putting more efficient data according to se…

  farax_x

  1 replies

  10 years, 6 months ago

  By: Gail Shaw

• setup alert for high cpu and high memory

  how can i set up alert for high cpu and high memory ?

  Almighty

  3 replies

  10 years, 6 months ago

  By: Justin Manning SA

• Replicate SQL server database(PUBLISHER) to Always ON Availability Groups (Listener)(SUBSCRIBER)

  https://msdn.microsoft.com/en-us/library/hh710046.aspx I have configured replication between Always…

  nari.koud

  1 replies

  10 years, 6 months ago

  By: nari.koud

• The media set has 2 media families but only 1 are provided.

  Hi All, it appears that I inadvertantly added a second file when creating a back up of a database t…

  Thom A

  1 replies

  10 years, 6 months ago

  By: Gail Shaw

• Active-Active cluster + AlwaysOn HA

  Hi all, we currently have an active/active cluster and want to AlwaysOn HA in another data center. …

  GabyYYZ

  4 replies

  10 years, 6 months ago

  By: GabyYYZ

• query needed

  I need to find the number of users hit on a database from last month ?

  ramyours2003

  3 replies

  10 years, 6 months ago

  By: Gail Shaw

• Issue Cluster AlwaysON SQL 2014 SP1

  Hello, I have a issue on AlwaysOn Group two nodes (SQL 2014 SP1 - Windows 2012 R2 Datacenter). I ha…

  ERIC CRUDELI

  16 replies

  10 years, 6 months ago

  By: Perry Whittle