Replication, SQL Server Administration

Configure Transactional Replication

This document describes the steps required to configure transactional replication between two SQL Server instances initialized using database backup. Transaction replication can be initialized by a snapshot or database backup. In case of large databases, initializing via snapshot may take longer than expected. Therefore, it’s better to initialize the replication via backup. Step 1: Configure Distribution Wizard The first step…

Continue Reading
Accidental DBA 100+ Tips and Tricks
SQL Server Administration

Accidental DBA Series

Are you an Accidental DBA? Consider yourself as an accidental DBA If you manage SQL Server with DBA not being your primary profile. You are only interested in getting work done such as troubleshoot adhoc SQL Server problems, maintaining SQL Server databases and then get back to your primary role of a Network Admin or Database developer. If you fall into this…

Continue Reading