• SQL Server
  • Log Shipping Tricks Demo
  • SQLCruise Alaska 2012 Pics
SQLSoldier News From the Frontlines

Tag Archives: Replication

Replication

Day 30 of 31 Days of Disaster Recovery (T-SQL Tuesday #40): Using Partial Availability and Initialize from Backup to Replicate a Partial Database

March 11, 2013 11:18 pm / 2 Comments / SQLSoldier

It’s been a tough and long road to 31 Days of Disaster Recovery. It’s been very difficult coming up with quality topic ideas for the series as we near the end. For day 30 of the series, I am combining a post on performing piecemeal restores with a post on filegroups for T-SQL Tuesday #40 … Read More →

Posted in: SQL Server / Tagged: 31 Days of Disaster Recovery, Disaster Recovery, Replication, T-SQL, T-SQL Tuesday, Undocumented Stuff

Day 29 of 31 Days of Disaster Recovery: Using Database Snapshots to Restore Replicated Databases in Test

February 24, 2013 8:29 pm / 1 Comment / SQLSoldier
31 Days of Disaster Recovery

For day 29 of my 31 Days of Disaster Recover series, I want to talk about restoring replicated databases from database snapshots. Someone asked me recently if I had any recommendations for speeding up their unit testing on replicated databases. He has to run unit tests over and over on replicated databases to ensure that … Read More →

Posted in: SQL Server / Tagged: 31 Days of Disaster Recovery, Disaster Recovery, Replication

SQL Saturday 108 (Redmond, WA) Session Files

February 25, 2012 7:44 pm / Leave a Comment / SQLSoldier

SQL Saturday 108 (Redmond, WA) Session Files Session files are now available for download. The zip file contains the PowerPoint slide deck and demo code. Zip file: ReplicationMagic.zip (5.2 KB) Included files: Demo: Initializing replication from a log backup InitializeFromLogPub.sql InitializeFromLogSub.sql Demo: Initializing replication from a filegroup backup using named filegroups FGByNameBackup.sql FGByNameRestore.sql Demo: Initializing … Read More →

Posted in: SQL Server / Tagged: Replication, SQL PASS, SQL Saturday

Undocumented Gotchas of Transactional Replication

December 17, 2011 3:06 pm / 5 Comments / SQLSoldier

Undocumented Gotchas of Transactional Replication This discussion started on Twitter via the #sqlhelp hash tag. The question that was asked is, “What are the undocumented gotchas of Transactional Replication? #SQLHelp”. I responded with several things that came to mind. I thought these would be good to capture in a blog post and hopefully others would … Read More →

Posted in: SQL Server / Tagged: General Discussion, Replication, Undocumented Stuff

SQL PASS Summit 2011: Session Files

October 17, 2011 7:06 am / Leave a Comment / SQLSoldier

SQL PASS Summit 2011: Session Files This past week was the SQL PASS Summit 2011 in Seattle, WA. I presented three sessions (regular session, lightning talk, panel discussion) plus ran a focus group on advanced certification and hosted a Birds of a Feather lunch table on disaster recovery. It was a busy, busy week. Below … Read More →

Posted in: SQL Server / Tagged: Disaster Recovery, Dynamic Management Views, Replication, SQL PASS, SQL PASS Summit, SSAS & BI, Tips & Tricks, Troubleshooting, Undocumented Stuff

Session Files for Replication Magic Presentation to WSSUG

August 26, 2011 8:13 am / Leave a Comment / SQLSoldier

Session Files for Replication Magic Presentation to WSSUG I presented my session on Replication Magic: Initializing from Backup to the Wichita SQL Server User Group last night. I took a little longer to post my session files so I could add comments to the SQL scripts. Session files are below. Powerpoint silde deck: ReplicationMagic.pptx (1.27 … Read More →

Posted in: SQL Server / Tagged: Internals, Replication, SQL PASS, Tips & Tricks

3 Log Shipping Techniques

June 24, 2011 5:46 am / 6 Comments / SQLSoldier

3 Log Shipping Techniques My new article for SQL Server Magazine titled 3 Log Shipping Techniques has been posted online and will appear in an upcoming print issue. This article is a look at some very interesting techniques that use log shipping in interesting ways. Mastering these tehcniques can save you a great deal of … Read More →

Posted in: SQL Server / Tagged: Database Mirroring, Disaster Recovery, High Availability, Replication, SQL Server Magazine

Counting Unreplicated Commands and Transactions

April 22, 2011 9:46 am / 20 Comments / SQLSoldier

Counting Unreplicated Commands and Transactions Someone asked me a question via Twitter today that I couldn’t possible answer 40 characters at a time. The question was about how to get the count of unreplicated transactions and commands from teh distribution server without using system views. Well, I do use one system view, but only because … Read More →

Posted in: SQL Server / Tagged: Internals, Replication, T-SQL, Tips & Tricks, Troubleshooting

SQL Server 2008 SP1 Too Old for Replication?

August 13, 2010 3:37 pm / 6 Comments / SQLSoldier

SQL Server 2008 SP1 To Old for Replication? We are in the middle of a platform upgrade project at work, and I was setting up replication on a newly flattened and rebuilt server with Windows Server 2008 R2 and SQL Server 2008 SP1. I remoted into the publisher server to set up replication. When I … Read More →

Posted in: SQL Server / Tagged: Replication, Troubleshooting

Making Sense of Replication Errors in Replication Monitor

March 27, 2010 8:10 pm / Leave a Comment / SQLSoldier

Making Sense of Replication Errors in Replication Monitor If you’ve ever had to deal with errors in Replication Monitor, your first experiences with it probably involved confusion. Sometimes the error messages are too generic and do not help you find a resolution. Replication Monitor also tells you the command that failed. This clears up everything, … Read More →

Posted in: SQL Server / Tagged: Replication, T-SQL, Troubleshooting

Post Navigation

← Older Posts
 
<

Remote DBA Services
- serious SQL Server expertise for less than a full-time DBA
My Articles
 
My Book
Check out my interview on

Extreme Data Recovery (with Argenis Fernandez)
10 Things all BI System Administrators Should Know
Upcoming Events
    All events shown in Pacific Time

    No events to show

RSS My SQL Server Magazine Articles

  • Database Mirroring for Disaster Recovery September 16, 2011
  • Comparative Review: Database Schema Comparison Tools August 24, 2011
  • 3 Log Shipping Techniques June 22, 2011
  • Hardening SQL Server June 20, 2011
  • Review: ScriptLogic Security Explorer for SQL Server February 8, 2011

Tags

31 Days of Disaster Recovery Architecture Automation CDC & Change Tracking Data Architecture VC Database Mirroring DBCC Denali Disaster Recovery Dynamic Management Views Extended Events Gamers & Geeks General Discussion High Availability How do I ... ? Humor Idera ACE Program Internals MCM Meme Monday Performance & Optimization PowerShell Professional Development Replication Security SQLBits SQL PASS SQL PASS Summit SQLRally SQL Saturday SQL Server Magazine SQL University SSAS & BI SSIS SSMS SSRS T-SQL T-SQL Tuesday tempDB Tips & Tricks Travel Troubleshooting Undocumented Stuff Whitepapers XML in SQL

News

Download my Powershell Scripts

The following scripts can be downloaded as text files. You will need to change the file extension to .ps1 in order to execute them.

Backup a database
Restore a database
Scan a server to find a free port
Query DNS to get the FQDN of a server


To see some examples of my other forms of writing, please visit my page on WritersCafe.org. It is almost exclusively horror fiction, but I sometimes throw other things in there too from time to time. There's one science fiction story, a couple of poems, and quite a few humor pieces as well.


Look for me in the SQL Q&A section of the August, 2007 issue of TechNet Magazine.
August issue of TechNet Magazine's SQL Q&A column

Protect our Heroes

© Copyright 2012 - Robert L Davis
Infinity Theme by DesignCoral / WordPress

Twitter Twitter 
LinkedIn LinkedIn 
TLF TLF RSS RSS 
WritersCafe WritersCafe 
SQLPASS SQLPASS 
Facebook Facebook
grab this