Tomorrow’s Expo
FREE SSWUG Expo – Maximizing SQL Server Uptime – Tomorrow 9am Pacific
SQL Server uptime is a key component of managing your SQL Server(s). Knowing what’s important, what options you have for building out solutions to help when things go wrong, is at the core of the responsibilities for those working with databases. This expo will feature information moving to SQL Server 2008 to get you started. You’ll learn about new features and important things that you’ll want to know about as you work with SQL Server 2008. We’ll also have segments on Transactional Replication for High Availability, Database Mirroring and even log shipping basics. Join us to learn about the key elements to making sure your systems are able to provide excellent uptime options for your business, clients and end-users. Sign up today. <- click to register…
Did you Test Your Disaster Recovery Plan?
As I read responses from our SSWUG readers regarding their sever room washing, it occured to me that they had good disaster recovery plans.
Most of us are good at putting together a disaster recovery plan for our servers. We have backups taken offsite, replication, mirroring, log shipping, co-locaiton, even SAN replication. Those are just a few of our recovery techniques. There are even third party tools that can keep you alive.
I wonder how many of the disaster recovery plans for companies impacted by 911 actually worked? I’ll bet someone out there has tried to gather some statistics. There are a lot of pieces to recovering from a disaster…and they may all be different.
What if you have to replace hardware and restore from tape? Some backup software is smart enough to ignore things that may be different from the previous machine to the one replacing it. But what about having to purchase a different hardware configuration? If you are working with servers, can you readily point your applicaitons to new servers? Did you try it? How long does it take?
Most big companies take this as a matter of course. But some of us smaller businesses forget that disasters do happen, and a trail run is the only way to make sure that our plan really works.
Got a story to share…send it to btaylor@sswug.org.
Cheers,
Ben
Featured Article(s)
Surface Area Configuration Tool (part 2 of 3)
In this part we will talk about all about full text service and how to use them wisely. Then we will discuss exactly what CLR is and how DAC can help when your server is unresponsive. We will talk about what SQL mail’s replacement is and what database mail is.
Featured Script
CheckAllTables – dbcc on all tables
Runs DBCC against all tables in the database. … (read more)