Option 1: Folder Explorer Go to folder explorer and type in … in the search box size:huge Option 2: TreeSize Free app https://www.jam-software.com/treesize?&cp=ProductAds&cp_kwd=TSfree_TSpro Note on Removing Files: hiberfile.sys ok to delete pagefe.sys should NOT be deleted .ost outlook files should NOT be deleted Although hiberfil. sys is a hidden and protected system file, you can safely... » read more
https://learn.microsoft.com/en-us/sql/database-engine/availability-groups/windows/upgrading-always-on-availability-group-replica-instances?view=sql-server-ver16 When upgrading a SQL Server instance that hosts an Always On availability group (AG) to a new SQL Server version, to a new SQL Server service pack or cumulative update, or when installing to a new Windows service pack or cumulative update, you can reduce downtime for the primary replica to only a single... » read more
To find out which version of Windows your device is running, press the Windows logo key key + R, type winver in the Open box, and then select OK. Select the Start button > Settings > System > About .
Go to Command Prompt
Status: Windows Failover Cluster fail to start any of the Roles All nodes in the Windows Failover Cluster are up. Identified several important event IDs that are common across all SQL nodes: 1069, 1205, 1254. Probable Causes: -SQL node names and AG name are not resolving or couldn’t register in the network. please look at the... » read more
Issue: Unable to generate pfx file from certificate manager. Certificate export have the option greyed out “Personal Information Exchange PFX”. Fix: Use PowerShell to generate the PFX file. The Certificates snap-in really doesn’t like to export PFX certificates, but PowerShell is happy to. You can use the Export-PfxCertificate cmdlet. Go to the certificates pseudo-drive by typing cd cert:\ at... » read more
Error: System.Transactions.TransactionManagerCommunicationException: Network access for Distributed Transaction Manager (MSDTC) has been disabled. Please enable DTC for network access in the security configuration for MSDTC using the Component Services Administrative tool. ---> System.Runtime.InteropServices.COMException: The transaction manager has disabled its support for remote/network transactions. (Exception from HRESULT: 0x8004D024) Fix: Configure MSDTC Open Component Services.Or, In Server Manager, select Tools, and... » read more
Microsoft has reamed Azure Active Directory (Azure AD) to Microsoft Entra ID for the following reasons: (1) to communicate the multicloud, multiplatform functionality of the products, (2) to alleviate confusion with Windows Server Active Directory, and (3) to unify the Microsoft Entra product family. https://entra.microsoft.com/#home References: https://learn.microsoft.com/en-us/azure/active-directory/fundamentals/new-name
Issue: When a server is created via replication, the sql server name might need to be changed. If not, you will see login issues in the database log and unable to see the job history. Resolution: Remember to restart SQL Server to apply the change.
Active Directory Need to create 2 AD objects. Cluster Host Listener Host Object needs to be… In the same AD folder. Add self, cluster, all customer hosts to the security tab with full control. Set the object to “Inactive” state. Inactive account. IP address will be enterer in at setup time. No need to add... » read more