Comprehensive SQL Server Database Operations and Replication Guide

This guide begins with fundamental SQL Server commands for creating and dropping databases, tables, indexes, and views, and includes examples such as CREATE DATABASE database-name , DROP TABLE tabname , and CREATE INDEX idxname ON tabname(col) .

It then presents essential data manipulation statements (SELECT, INSERT, UPDATE, DELETE) and advanced query operators like UNION, EXCEPT, INTERSECT, along with various join types (LEFT, RIGHT, FULL) and GROUP BY usage.

Database maintenance topics are covered, including index rebuilding ( DBCC REINDEX ), shrinking databases ( DBCC SHRINKDB ), and backup verification ( RESTORE VERIFYONLY FROM DISK='...' ).

The article details the configuration of linked servers and replication, showing how to add a linked server with exec sp_addlinkedserver 'srv2', '', 'SQLOLEDB', 'srv2_ip' and set up login credentials using exec sp_addlinkedsrvlogin 'srv2','false',null,'username','password' .

It explains snapshot replication setup steps, including creating a shared snapshot folder, configuring the SQL Server Agent, and registering publishing and subscribing servers.

Finally, a sample synchronization stored procedure create proc p_process as ... demonstrates how to update, insert, and delete records on a remote server to keep two tables in sync, and shows how to schedule this procedure with SQL Server Agent jobs.