Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Downtime

By Steve Jones,

http://cdn.venturebeat.com/wp-content/uploads/2009/09/downtime.jpgSomeone sent me a note recently asking about how to handle unexpected downtime. In an editorial I mentioned that a 7TB database isn't that large, and this person told me that they had an issue with a 1TB database and running DBCC resulted in a 4 hours of unexpected downtime. The person asked if small businesses needed to accept downtime for serious maintenance.

I think that it's rare you run into DBCC issues that require downtime, but when you do, then that downtime is needed. I'm not sure what else you can do since DBCC repair issues often indicate some fundamental hardware issue. I suppose that you could move to new hardware, but you still need to ensure that your database is intact and working.

A restore from backup might be quicker in these situations, but that will requires some downtime, and it's something that you have to live with. We still have systems that will fail and need rebuilding, and probably always will.

I know some companies can afford redundant hardware and failover to secondary systems when they need to check their primary servers. A second copy of the database may or may not allow you to continue to function if you had corrupt pages on your primary, depending on how the data is moved over.

Most of us, however, just have to live with downtime. If anyone has other ideas or stories on dealing with unexpected maintenance downtime, I would be interested in hearing them in the discussion below.

Steve Jones


The Voice of the DBA Podcasts

Everyday Jones

The podcast feeds are available at sqlservercentral.mevio.com. Comments are definitely appreciated and wanted, and you can get feeds from there. Overall RSS Feed: or now on iTunes!

Today's podcast features music by Everyday Jones. No relation, but I stumbled on to them and really like the music. Support this great duo at www.everydayjones.com.

You can also follow Steve Jones on Twitter:

Total article views: 161 | Views in the last 30 days: 1
 
Related Articles
ARTICLE

Downtime

One thing most DBAs try to avoid whenever possible is unexpected downtime. It still happens, and we ...

ARTICLE

Downtime

Most of us are working to prevent downtime in our systems. However Netflix thinks a little forced do...

ARTICLE

Podcast Announcements

Podcast Feeds

ARTICLE

Use Backup/Restore to Minimize Upgrade Downtimes

Learn how to minimize downtime while moving databases using Backup/Restore in SQL Server.

BLOG

Podcasting

A new video setup is on the way!!!! Actually I'll do a couple podcasts on podcasting over the hol...

Tags
editorial    
 
Contribute

Join the most active online SQL Server Community

SQL knowledge, delivered daily, free:

Email address:  

You make SSC a better place

As a member of SQLServerCentral, you get free access to loads of fresh content: thousands of articles and SQL scripts, a library of free eBooks, a weekly database news roundup, a great Q & A platform… And it’s our huge, buzzing community of SQL Server Professionals that makes it such a success.

Join us!

Steve Jones
Editor, SQLServerCentral.com

Already a member? Jump in:

Email address:   Password:   Remember me: Forgotten your password?
Steve Jones