SQL Server 2019 - Administration

• Topics

  Started by

  Posts

  Last post

• Failed restore database

  Hi All , I have issue restoring small database . SQL version : SQL 2014 In the server , At first I …

  WhiteLotus

  2 replies

  11 months, 2 weeks ago

  By: Grant Fritchey

• Veeam Queries.

  Good morning campers! I'm hoping to pick your collective hive brain wrt Veeam / SQL backup integrat…

  goodtimecharlie

  3 replies

  11 months, 3 weeks ago

  By: goodtimecharlie

• SSISDB: finding executions from an Execute Package Task

  I am trying to find usage and non-usage of package sin my ssisdb catalog. I have a decent query bel…

  Lowell

  1 replies

  11 months, 3 weeks ago

  By: Lowell

• How to commit transaction log during a large ETL process

  Hello SSC! First, I would like to thank everyone who has responded to my posts. This website has he…

  Lord Slaagh

  6 replies

  11 months, 3 weeks ago

  By: Jeffrey Williams

• Error Login from an untrusted domain

  Hi All, I found something a little strange in my SQL Server Error Log, There is an error message: L…

  Deni Kusdeni

  1 replies

  12 months ago

  By: Deni Kusdeni

• SPID is suspended but the wait type is NULL

  Hello experts, I have always assumed that if there is no wait going on for a SPID, that its status …

  webrunner

  1 replies

  12 months ago

  By: webrunner

• backups failure

  Hello All, We have a domain account running sqlserver service.this account has r/w access to a netw…

  mtz676

  8 replies

  12 months ago

  By: Mr. Brian Gale

• Capture long transact query using SQL Server performance condition alert feature

  I created a SQL Alert trying to capture long query transaction under the  SQL Server Agent\Agent wi…

  pcq0125

  3 replies

  12 months ago

  By: pcq0125

• SSRS configuration issue - cannot connect to SQL Server

  I had some issues with a local (development computer) Report Server where the configuration manager…

  bob-596435

  14 replies

  1 year ago

  By: bob-596435

• Question about SQL Certs and DNS aliases

  About 15 years ago we started creating DNS aliases for each database. This allowed us to move datab…

  TangoVictor

  2 replies

  1 year ago

  By: TangoVictor

• SQL Server Transaction Replication Issue: BIT Columns Not Refreshing

  Hello Everyone, I have a database that is being copied to six subscribers with several publications…

  krunalpatel155

  1 replies

  1 year ago

  By: krunalpatel155

• Cluster Timeout Settings to handle transient network outages

  I have an Availability group with 2 replicas on the same subnet.  We've been experiencing short net…

  askcoffman

  1 replies

  1 year ago

  By: Mr. Brian Gale

• SQL Server Availability Group Database Backup Missing Data

  I have a production SQL2019 Enterprise SQL Server which hosts an Availability Group with 12 small t…

  KathyGibson96

  3 replies

  1 year ago

  By: rothj

• Bidirectional replication question

  Does anyone know where I can find actual documentation on how to setup bidirectional transactional …

  cphite

  2 replies

  1 year ago

  By: cphite

• SQL and GPX data from Garmin etrex GPS and Garmin Watch

  Hi all, I am looking for help. My ultimate goal is to build a platform that allows me to record all…

  bryanrawiri

  11 replies

  1 year ago

  By: Steve Collins