For the past couple of weeks, I’ve been working on a series of articles on building a scale-out SQL Server 2008 R2 Reporting Services Farm. Part 1 of this series is already available on MSSQLTips.com. This was inspired by the SQL Server 2008 Failover Cluster installation series as I’ve been searching for available guides online […]
PostDisaster Recovery Is More Than Just Technology Part 3: The Lion, The Switch and The Wardrobe
You were in your favourite bar one Saturday night when, suddenly, you hear your mobile phone ring. You pick up the phone and heard the sound of a screaming voice on the other end (no, it’s not your wife telling you to go home and take out the trash). The background noise is preventing you […]
PostDisaster Recovery Is More Than Just Technology Part 2: The Alphabet Soup
In my previous blog post, I talked about high availablity and disaster recovery (HADR) and how it is more than just the underlying technology that keeps the entire strategy intact. In this blog post, I’ll describe a few acronyms – sometimes called buzzwords – that are commonly referred to in HADR projects and implementations (I […]
PostDisaster Recovery is More Than Just Technology Part 1
While I was at the PASS Summit 2010, I’ve spent a fair amount of time at the Ask-the-Experts table on high availability, disaster recovery and virtualization. Conference attendees with different requirements on high availability and disaster recovery come to these tables and ask questions. I’ve spent a fair amount of time doing high availability and […]
PostYour poor man’s SQL Server log shipping-PowerShell version
In 2008, I was privileged to be a part of a project to write a chapter for a book that was for a good cause. SQL Server MVP Deep Dives became an avenue for a lot of the SQL Server MVPs to share their expertise for the benefit of not just the technical community but […]
PostRetrieve Default SQL Server Backup Folder using PowerShell
As I’ve been translating a lot of my TSQL script to Windows PowerShell with SMO, here’s another articleI wrote on how to check for the default SQL Server backup folder
PostInstalling SQL Server 2008 Failover Cluster on a Windows Server 2008 R2?
I did a demo fest on installing SQL Server 2008 Failover Cluster on a Windows Server 2008 system a few weeks back for a user group event and the attendees requested that I post more information about how to do a slipstream of service pack in a SQL Server 2008 installation. With Windows Server 2008 […]
PostCheck the last backup date in SQL Server using Windows PowerShell
This article highlights how to use Windows PowerShell to retrieve database properties using SMO. Notice how easy it is to check the database properties using pretty common syntax One of the challenges I have when I was starting out as a SQL Server DBA was to check for the last backup date for a database. […]
PostA thousand and one reasons for a generic error message.
I’ve spent a couple of hours trying to troubleshoot a clustered SQL Server 2008 installation. All I know is that it throws this error message after the installation process and does not give me any clue at all The cluster resource ‘SQL Server (MSSQLSERVER)’ could not be brought online. Error: The group or resource is […]
PostBroken BACKUP and RESTORE sequence?
Have you ever had the to scratch your head because your database backups won’t work even if you are practically sure that you have tested them properly? Imagine this – you have a regular FULL and DIFFERENTIAL database backups working together as part of your backup process. Your FULL backups run every Sunday and your […]
