SQL Server 2016 - Administration

• Topics

  Started by

  Posts

  Last post

• Unauthorised action - installing sql 2016 on Windows 10

  Hi All I have been trying for four days now to install sql 2016 on Windows 10. I previous had a per…

  pnr8uk

  4 replies

  8 years ago

  By: pnr8uk

• Troubleshooting disk bottleneck

  I am doing some IO testing on a newly build server using Diskspd. diskspd -b8K -d300 -o8 -t8 -…

  jesijesijesi

  2 replies

  8 years ago

  By: Sue_H

• Best approach to achieve high availability and disaster recovery?

  We are deploying SQL servers at two geographically distant sites. The bandwidth between two sites i…

  xiao.cheng 74262

  3 replies

  8 years ago

  By: quackhandle1975

• SQL 2016 SP1 install failed, SP1 uninstall also failed

  Hi Guys I haven't had much top do with SQL 2016 but attempted to install SQL2016 SP1 on a server In…

  alnor

  1 replies

  8 years ago

  By: andreas.kreuzberg

• different configured disc block size on Log shipped Secondary

  I am seeing an error on our secondary server where we are sending our Log shipped database transact…

  PearlJammer1

  2 replies

  8 years ago

  By: PearlJammer1

• MS login creation date question

  Hello experts, I have a noob question. Do the following server principals get re-created each time …

  webrunner

  2 replies

  8 years ago

  By: webrunner

• sys.databases

  Hello.In an instance i found a database with the next values:snapshot_isolation_state = 0is_readcom…

  msimone

  3 replies

  8 years ago

  By: Gail Shaw

• Cannot remove/delete SQL Server job

  I have a maintenance plan that was removed and it won't delete from the SQL Server Agent Jobs. When…

  WC_Admin

  1 replies

  8 years ago

  By: WC_Admin

• Using AlwasyOn Failover Cluster Instance in conjunction of Peer to Peer Transactional Replicaiton

  Hi all, We are deploying two physical sites each with writable/readable access to its local SQL ser…

  xiao.cheng 74262

  2 replies

  8 years ago

  By: xiao.cheng 74262

• Error when running SQL Agent Job

  When running a SQL Server agent job by right-clicking it and choosing to Start at Step 1, the follo…

  callen-557064

  2 replies

  8 years ago

  By: itpcpro

• Script to Copy SSRS Content between Report Servers

  Any one know where can I download the script for copying SSRS reports to another server.And does it…

  sqlfriend

  3 replies

  8 years ago

  By: Sue_H

• Adding new server to AG fails, log file errors - the log in this backup set...which is too recent to apply to the database?!

  Ok, I am at a lost to understand this. I am trying to add a new server to an AG.  1. &nbs…

  WebTechie

  3 replies

  8 years ago

  By: WebTechie

• Static Port conflicts

  I have a cluster with 4 nodes. Each node has two instancesinstalled one for dev and one for preprod…

  WonderPra

  2 replies

  8 years ago

  By: WonderPra

• Suggestions/Guidance for SQL 2016 Always on Datawarehouse

  Forum, Currently we are implementing SQL Server 2016 Always On for our DataWarehouse, i have few do…

  JSB_89

  1 replies

  8 years ago

  By: Steve Jones - SSC Editor

• Different plan on secondary vs Primary

  I have found an issue where a query plan on the secondary replica is much different than the primar…

  SqlServerDBA318

  5 replies

  8 years ago

  By: Grant Fritchey