Posts by Salma Shaik

Troubleshooting Tips for Seamless SQL Server Transactional Replication

SQL server issue and solution Troubleshooting Tips for Seamless SQL Server Transactional Replication Introduction: Transactional Replication is a powerful High availability feature in SQL Server that allows the consistent and…

Read More

Unlocking Solutions: Common Errors in SQL Server Database Restoration

SQL server issue and solution Unlocking Solutions: Common Errors in SQL Server Database Restoration Introduction: The process of restoring Databases in SQL Server is a fundamental responsibility for administrators. This…

Read More

Inplace Upgradation

                                  Inplace Upgradation Introduction: Upgradation involves overwriting existing SQL Server instance and upgrading from…

Read More

Log Shipping issues in SQL Server. Out of Sync is the Common issue in Log Shipping. It can be raised when Transaction Log Backups are not applied to the Secondary Server.

SQL Server issue and solution Error:  Log Shipping issues in SQL Server.   Out of Sync is the Common issue in Log shipping. It can be raised when Transaction Log Backups…

Read More

To Fix SQL Server Always on Availability Group Database in Secondary Replica is Not Synchronized with Primary Replica.

SQL Server Issue and Solution  Error Summary:   To Fix SQL Server Always on Availability Group Database in Secondary Replica is Not Synchronized with Primary Replica.    REASON:  If there is…

Read More

SQL Server Database in Suspect Mode

SQL server issue and solution  Error Summary:   Suspect is a state where database becomes inaccessible due to different reasons.  These are the few reasons why the database will go to…

Read More

Error: Transaction Log File is full at the primary Replica of the Always on Availability Group.

SQL server issue and solution   Error Summary:  Assume we receive 9002 error message when trying to execute a new query on one of the Always on Availability Group Databases.  Reason…

Read More

ERROR:26(A network-related or instance-specific error occurred while establishing a connection to SQL Server.)

SQL server issue and solution Error summary:  The users might often see the error “SQL Network Interfaces, error:26- Error Locating server/Instance Specified”  This error message may prompt while connecting to…

Read More