List Server Extended Properties

Simply lists all server extended properties.

Find Database Schema and Objects Changes

This procedure will execute, taking two parameters, (the 2 db names, and will then list out the major object and schema changes for you. It is pretty sraight forward and suggestions are appreciated. It's a good utility for a DBA to track changes after upgrades, etc.. Each portion is easily convertable to a stand alone […]

Log Shipping vs. Replication

SQL Server high availability. Log shipping or replication, clustering or some other solution. It's a challenge and as companies grow more dependent on their databases, it's one that more and more DBAs face everyday. Paul Ibison has taken a look at how log shipping and replication can be compared in the quest for high availability.

Script to automatically restore needed log-backups

Given a backupfile with a lot of sequential log-backups, this script automatically restores just those backups out of the file, which are necessary to bring the database up to a given timelag relating to the original database.Params are path to backupfile, name of the db to restore to, timelag in minutes.

Script to transfer logins to second server

Modification of DR_Script_Logins.sql by Bruce Canady.Puts out a script to add new logins or change the password of existing logins.I insert the output into a table in my production-db.   insert database.dbo.login_table exec master.dbo.dr_script_loginsThat way its backed up with the data, and the logins can be restored anywhere by the script i added at the […]

Replication Gotcha - Columns with Defaults

Some days the simplest things go wrong. On this particular day Andy tried to remove a column that was part of an article in a transactional publication, wound up in an inconsistent state that required a snapshot to fix. Deeper investigation reveals the cause and a work around.

Find Replicated columns of certain data types

Script to look at all articles in all publications in a DB to find replicated columns of certain data types.  I used this to find BLOB columns that we wanted to remove from the articles.

Snapshot Replication for the Beginner - Part 2

This article covers how to build the snapshot subscription without getting bogged down in too many low level details. You'll learn enough here to get started experimenting and get results. Depending on comments from you, we may ask Andy to move on to transactional replication or to dig deeper into snapshot options. Tell us what you think!

You are a database architect of a SQL...

SQL 2000 Replication Architecture

New author! Mahesh presents a solid overview of the replication architecture of SQL 2000.