There are some skills which are extensions of your instincts, and which you can only learn though years of experience. Matt Simmons has this brought home by the fact that he was recently minutes away from a data-loss disaster, and he doesn't quite know how he prevented it.
2012-12-13 (first published: 2010-03-25)
7,373 reads
This article describes how to use Microsoft SQL Server 2005 or Microsoft SQL Server 2008 log shipping to create a disaster recovery farm in a geographically distributed data center for Microsoft Office SharePoint Server 2007 with Service Pack 2 (SP2). By using this configuration, you can provide a disaster recovery site that provides current search results when a failover occurs. The article assumes that you are familiar with the concepts and terms presented in Plan for availability (Office SharePoint Server).
2009-10-09
2,570 reads
High-Availability depends on how quickly you can recover a production system after an incident that has caused a failure. This requires planning, and documentation. If you get a Disaster Recovery Plan wrong, it can make an incident into a catastrophe for the business. Hugo Shebbeare discusses some essentials, describes a typical system, and provides sample documentation.
2009-09-14
4,158 reads
Many articles on database administration take the perspective of trying to help you do your job better. We thought we might take a different tack and poke a little fun at some of more egregious mistakes we've seen over the years at IT shops.
2009-08-27
9,660 reads
Two sets of scripts to help setup mirroring or remove mirroring - handy during disaster recovery exercise
2010-06-07 (first published: 2009-03-17)
2,627 reads
Tjay Belt brings us a quick and easy DR solution that might provide you some protection if you don't have a DR plan and want some lessons learned in this area.
2008-07-31
8,328 reads
James DiMauro brings us a story of how a transaction log was deleted and then recreated. (from July 2008)
2009-08-07 (first published: 2008-07-14)
20,754 reads
So, how do you prepare for a master rebuild and what do you do afterwards? Hopefully this checklist will give you an idea.
2008-07-08
4,416 reads
Have you seen disasters in your environment? I would bet you have at some point. Let's see if our top 13 disasters matches your experiences.
2008-06-24
3,790 reads
2008-04-22
4,256 reads
By Steve Jones
I don’t have SQL Server installed on my laptop. In an effort to keep...
Slow-running queries can degrade your Redshift cluster’s performance and lead to increased costs. Identifying...
By gbargsley
If you've been here before, you know this blog is usually about SQL Server,...
Hi all Can I get some perspective from the community please on performing in-place...
Comments posted to this topic are about the item How Long is a Long...
Comments posted to this topic are about the item T-SQL Trigonometric Functions in SQL...
In SQL Server 2025, a long I/O is recorded in the error log with message 833. How long much an I/O request be outstanding before this message is written to the log?
See possible answers