Naveen Khandelwal We had one activity planned which was related to windows hostname and SQL server name change. DB Servers Setup Information: It was a 2 node windows cluster, Node1 & Node2. SQL server Always On was configured on this setup. 4 Synchronous Always On Groups (AG1, AG2,AG3,AG4) were setup and Node1 was acting as Primary. Always … Read more
Recently, we had to retrieve SQL Server License Keys for existing SQL Server setups due to auditing requirements. Existing database server setups spanned from SQL 2008 to SQL 2019. PowerShell Script mentioned in below article could be used to retrieve product key for SQL server 2008 , 2008 R2 & 2012. https://mspowershell.blogspot.com/2010/11/sql-server-product-key.html We made small … Read more
In Previous article, we discussed – Where Are various Replication Agent Jobs Running ? This is very important for quick troubleshooting of replication issues. In this article, we will try to understand various files created by Snapshot Agent when a Snapshot is created. If we go to snapshot folder (Check location in Publication Properties), we … Read more
SQL server Replication is one of the most interesting topic. Transactional Replication is most widely used for various purposes. When any issue related to Transactional replication occurs, many DBAs face difficulty in identifying locations of Replication Agent Jobs. Snapshot Agent, Log Reader Agent & Distribution Agent are three main replication related jobs whose history need … Read more
Recovery Model is the most important concept in Microsoft SQL Server. Recovery model controls type of backups taken for a database. It can also control transactional log truncation and Point-in-Time Recovery of a database. On any full-fledged SQL server instance deployed on a physical server or a virtual machine, we can have various databases with … Read more
One of my DBA friend was troubleshooting some issue on a SQL database server hosted on AWS EC2 Windows Instance. He was able to take remote desktop connection of EC2 instance. But as part of troubleshooting, he needed to see various details for that EC2 instance on AWS portal. He was able to login on … Read more