SQL Server 2017 - Administration

• Topics

  Started by

  Posts

  Last post

• Log Shipping Not Able to Restore Log Files in Secondary

  I'm attempting to set up log shipping from SQL Server 2005 Standard to SQL Server 2017 Standard. I …

  regnar

  1 replies

  3 days, 10 hours ago

  By: regnar

• auto-generate-sql-server-restore-script-from-backup-files (bak + trn) -in-a-directory for multi databases

  Hello everyoneI am looking to generate a restoration script for hundreds of databases with their ba…

  abdalah.mehdoini

  9 replies

  4 weeks ago

  By: Srinivas Merugu

• Index Fragmentation

  I am looking into fragmentation in one of my databases and ran across these stats - should I be reb…

  stevec883

  14 replies

  4 weeks, 1 day ago

  By: Jeff Moden

• Proc cache slowly decreasing in size until restart is required

  In SQL 2017 (14.0.3475.1) the size of the proc cache is slowly decreasing. The workload on the inst…

  Bouke Bruinsma

  4 replies

  1 month ago

  By: Bouke Bruinsma

• Proc cache slowly decreasing in size until restart is required

  In SQL 2017 (14.0.3475.1) the size of the proc cache is slowly decreasing. The workload on the inst…

  Bouke Bruinsma

  3 replies

  2 months ago

  By: Jeff Moden

• Events of System_health extended event serious or not

  I have listed the event names present in my system_health extended event report. Based on these gro…

  IT researcher

  1 replies

  3 months ago

  By: IT researcher

• % processor Time in Activity monitor is greyed out

  When I connect to my SQL Server using SQL Server Management Studio (SSMS) from a remote computer, t…

  IT researcher

  1 replies

  3 months, 4 weeks ago

  By: IT researcher

• Microsoft Recommendations for Update Stats?

  I have an application team that is insisting on daily (and for some, weekly) jobs for UPDATE STATIS…

  Brandie Tarvin

  17 replies

  4 months ago

  By: Jeff Moden

• Vulnerability Assessment removed?

  In Brent Ozar's list of links today, I learned that Microsoft has removed the Vulnerability Assessm…

  cgumprich

  4 replies

  4 months ago

  By: Anja

• Manual Distribution Database Cleanup

  Hi All. I have a reasonably straightforward transactional replication setup. I had two databases on…

  five_ten_fiftyfold

  2 replies

  4 months, 1 week ago

  By: five_ten_fiftyfold

• Indexing Recommendation Tools for SQL Server

  I'm looking for indexing recommendations for the entire SQL Server database, not just for individua…

  IT researcher

  3 replies

  5 months ago

  By: Jeff Moden

• Log Backup failed on Secondary Replica

  I have a scenario where log backup is getting failed in Secondary replica on AlwaysOn availability …

  aroojsql

  2 replies

  5 months, 1 week ago

  By: keyurinbox

• SQL Connectivity issues after changing default port

  Hi, I have a test server with two SQL server instances running on it. Both are SQL 2017 STD ) One i…

  keyurinbox

  1 replies

  5 months, 1 week ago

  By: keyurinbox

• Linked server and trouble between manager and agent

  Hello, I have a problem and i don´t understand it. After to link a server, i execute delete top(1)…

  msimone

  3 replies

  5 months, 2 weeks ago

  By: Johan Bijnens

• Object-level permissions on dbo

  I'm in a bit of a pickle. I had to remove all user permissions from a database but when a user test…

  Brandie Tarvin

  9 replies

  5 months, 3 weeks ago

  By: Brandie Tarvin