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 →
Tag Archives: Replication
Day 29 of 31 Days of Disaster Recovery: Using Database Snapshots to Restore Replicated Databases in Test
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 →
SQL Saturday 108 (Redmond, WA) Session Files
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 →
Undocumented Gotchas of Transactional Replication
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 →
SQL PASS Summit 2011: Session Files
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 →
Session Files for Replication Magic Presentation to WSSUG
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 →
3 Log Shipping Techniques
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 →
Counting Unreplicated Commands and Transactions
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 →
SQL Server 2008 SP1 Too Old for Replication?
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 →
Making Sense of Replication Errors in Replication Monitor
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 →
Twitter
LinkedIn
TLF
RSS
WritersCafe
SQLPASS
Facebook