SQL Server 2016 - Administration

• Topics

  Started by

  Posts

  Last post

• Log Shipping

  Hi, SQL server agent is running with the same service account on primary and secondary servers…

  adisql

  4 replies

  8 years ago

  By: adisql

• Remove TDE

  Hi, is the resinstalling sqlserver removes the TDE? Thank you!!

  adisql

  3 replies

  8 years ago

  By: adisql

• Move master DB due to restricted file permissions

  My apologies if this is in the wrong forum. I normally use sql server localhost on my work compute…

  alastair.dewar1979

  8 replies

  8 years ago

  By: Jeff Moden

• What does your backup process look like?

  Hi, I'd be interested to hear how most of you have your backups set up. I know a lot of it depends …

  Mike Scalise

  43 replies

  8 years ago

  By: Mike Scalise

• Index rebuilding on a AWS RDS SQL server instance

  Hi, Is there a need for Index rebuilding for the AWS RDS SQL server -2016 version, considering RDS …

  Agnii

  4 replies

  8 years ago

  By: eshults5

• GDPR Requirements and Encryption

  So long story short, I have to encrypt all our databases in my system to satisfy GDPR requirements.…

  eshults5

  9 replies

  8 years ago

  By: Eirikur Eiriksson

• New AG environment

  Looking a new 2016 build, all enterprise Edition licensed at VM host. Was going to have AG with re…

  tcronin 95651

  4 replies

  8 years ago

  By: eshults5

• Changing database owner SID

  Are there negative implications if I change the database owner SID?I need to change the SID for ins…

  Eliyahu

  1 replies

  8 years ago

  By: andreas.kreuzberg

• SSMS failing to install on windows 10

  Ssms keeps hanging on the isolated VS step and fails with error 80070643

  hurricaneDBA

  32 replies

  8 years ago

  By: Sue_H

• SQL Server name change

  Hi, we have standalone default SQL server instance.Now we are going to change the co…

  adisql

  2 replies

  8 years ago

  By: adisql

• Partitioning An Existing Table With A Columnstore Index ?

  Hi,does it make sense to additionally partition a table (FactTable with 5-10 million rows) with a c…

  info 58414

  4 replies

  8 years ago

  By: Jeff Moden

• Logshipping

  Hi, Peimary server Version: Microsoft SQL Server 2016 (RTM) - 13.0.1601.5 (X64) Apr 29 20…

  adisql

  4 replies

  8 years ago

  By: Sue_H

• SQL Server Agent stopped - Event ID 17052

  I've had back to back Saturdays where our SQLServerAgent (Test Instance) has stopped with an Event …

  krishnp92

  3 replies

  8 years ago

  By: Thomas Rushton

• SQL Replication - 2016 to 2008 r2

  I understand SQL Server is supported for replication from versions two up and two down.  Howev…

  DentalDBA

  1 replies

  8 years ago

  By: frederico_fonseca

• Second differential backup smaller than first one after full backup?

  Hi, I'm testing some new backup processes here (a weekly job and a daily job). I ran my weekly job …

  Mike Scalise

  13 replies

  8 years ago

  By: Jacob Wilkins