SQL Server 2019 - Administration

• Topics

  Started by

  Posts

  Last post

• How to find the root cause for log .ldf file increased suddenly to 500 gb

  How to find the root cause for log .ldf file increased suddenly to 500 gb we dont know what made in…

  naga.rohitkumar

  6 replies

  2 years ago

  By: Jeff Moden

• DataBase Already Exists Metadata Error

  Ahoy, Seems like i renamed my SSAS Database accidently and only changed the CAPS (Old_NAME) to (Old…

  ktflash

  1 replies

  2 years ago

  By: ktflash

• Mirroring and database access problems during database migration

  I have a system with two servers and three client workstations. Servers were configured to work as …

  Lamija37

  2 replies

  2 years ago

  By: Lamija37

• Additional Monitoring on RDS Sql Server

  Hi,   Can someone let me know if we need to setup any additional monitoring on RDS Sql Server …

  sql_2005_fan

  1 replies

  2 years ago

  By: Grant Fritchey

• Combining Two Rows in to 1Row

  Good day Experts, How can i combine these two rows into one in sql .So i want it to be one row. Ma…

  tmmutsetse

  3 replies

  2 years ago

  By: Grant Fritchey

• Create a dynamic script to create view for all tables having MAX columns

  Hi I need some help on this request Create a dynamic script to create view for all tables having MA…

  rpalani65sql

  16 replies

  2 years ago

  By: Jeff Moden

• File Share Witness - Off line

  Hi all, I am running Windows Server 2019, SQL Server 2019, Windows Fail over cluster and Availabili…

  jayoub

  1 replies

  2 years ago

  By: jayoub

• Veeam backups and Tlog maintenance

  Was testing with VEEAM to do SQL backups... Using app aware, the set up indicates the tlog would be…

  daniel.manke

  2 replies

  2 years ago

  By: deubel_m

• The audit file has not been deleted.

  Hello I recently set up an audit on my server to track some connections. ,The audit works correctly…

  abdalah.mehdoini

  1 replies

  2 years ago

  By: Ant-Green

• ALTER SERVER AUDIT -- need to supply 1 predicate with 2 values to filter on

  Looking for example FILTER containing multiple values in the predicate -- to apply to "ALTER SERVER…

  Express12

  6 replies

  2 years ago

  By: Ant-Green

• Minimal permission to stop a SSIS execution from Active Operations dashboard?

  What is the minimal permission to allow a user (who is not a member of the SYSADMIN or SSIS_ADMIN r…

  Eric M Russell

  5 replies

  2 years ago

  By: Emperor100

• Server Audit Specifications, Audit Action Type -- SELECT UPDATE INSERT DELETE

  I'm trying to capture an audit of ANYONE logging into a database on my SQL 2019 Enterprise instance…

  Express12

  2 replies

  2 years ago

  By: Express12

• add a group in local security policy

  i want to add a group in multiple local security policy like 'Adjust memory quotas for a process', …

  Abhishek

  1 replies

  2 years ago

  By: Ant-Green

• SPN issues. SQL 2019 Server 2022, domain service account.

  Hello, I'll just get straight to it. I am trying to set up a SQL Server 2019 AlwaysOn AG on Windows…

  Jammyuk

  5 replies

  2 years ago

  By: Johan Bijnens

• Log File v.large, has not been backed up.

  Say a production DB is used in office hours only. Scenario A DB under Full recovery model. NO Tran …

  terry999

  4 replies

  2 years ago

  By: Emperor100