SQL Server 2017 - Administration

• Topics

  Started by

  Posts

  Last post

• Login sa failed

  Hi All,  Please advise,  Logon    Login failed for user 'sa'. Reason:…

  sizal0234

  13 replies

  6 years, 9 months ago

  By: Johnson Welch

• scale out existing repica(s)

  Hello, Is there a good inexpensive way to scale out an existing primary replica on SQL Server 2016 …

  barsuk

  3 replies

  6 years, 9 months ago

  By: barsuk

• SQL Server 2012 and SQL Server 2017 together

  Hi.  I have a situation where I need to run SQL Server 2017 and SQL Server 2012 side by side f…

  PHXHoward

  1 replies

  6 years, 9 months ago

  By: Evgeny Garaev

• same port 5022 IN MIRORING

  Hello everyoneI need to configure mirroring in an AWS cloud environmentthe two machines are physica…

  abdalah.mehdoini

  1 replies

  6 years, 9 months ago

  By: goher2000

• Learning SQL Server 2017 Administration

  Is there a good book or material to learn the product from a DBA perspective.  I will probably…

  rondebbs 48050

  3 replies

  6 years, 9 months ago

  By: aksel.rohtsalu

• Unable to switch SSRS service account to local

  Hi, I need to switch the ssrs account from domain to local account.Now, sql server configurati…

  sizal0234

  2 replies

  6 years, 10 months ago

  By: sizal0234

• blocking for same query on user DB

  Hello Gurus, In Production I noticed one issue and need your help. On the web page when we click on…

  sqlguy80

  6 replies

  6 years, 10 months ago

  By: Jeff Moden

• Sql 2017/2019 unattended installs tempdb files

  Trying to verify that what I am seeing is intended behavior not something I have messed up.  W…

  craig.fullen

  5 replies

  6 years, 10 months ago

  By: craig.fullen

• Re-routing requests by SQL Server

  Hi, In SQL Server 2016, 2017 in the Always-ON configuration is a good idea to re-routing SQL reques…

  Mr_Q

  1 replies

  6 years, 10 months ago

  By: G K

• login failure error for syspolicy_purge_history job on multiple instances server

  I have built two instances on SQL 2017. One is default instance, The other is a named instance for …

  sqlfriend

  3 replies

  6 years, 10 months ago

  By: Harold Buckner

• Is it possible to recover only one corrupted file in a filegroup of multiple files from the backup

  I have the backup of the filegroup and each file. It has 3 .ndf files. If one is corrupted can I re…

  elea.grig

  1 replies

  6 years, 10 months ago

  By: HappyGeek

• Is SQL Server Reporting Services (SSRS) free for Developer Edition?

  While trying to install SSRS I get just 2 options 1) evaluation for 180 days 2) Entrace for product…

  elea.grig

  2 replies

  6 years, 10 months ago

  By: elea.grig

• Capture all SQL Connection to table and schedule a job

  Does anyone have a script to Capture all SQL Connection to table and schedule a job that delet…

  hello_san

  5 replies

  6 years, 10 months ago

  By: goher2000

• High Availability Group Failover SNAFU

  I'm kicking tires and driving into ditches testing our proposed AG confiuguration when I come acros…

  keassnow

  2 replies

  6 years, 10 months ago

  By: keassnow

• Arithmetic Overflow when comparing working select items

  Hello, I have a working query that gives me the data I'm looking for. SELECT DISTINCT CAST(COALESCE…

  lonnie.hull

  11 replies

  6 years, 10 months ago

  By: lonnie.hull