January 5, 2009 at 5:58 am
Hi Pals,
Can anyone suggest few links on disaster recovery scenarios for SQL Server 2005.
Example : IF "master" database is corrupted what needs to be done.
.. so on
looking forward for more inputs!
Thank You.
January 5, 2009 at 8:31 am
If a database is corrupt, all you can do is restore it. Anything else is a last ditch effort to recover information because you failed to backup your data properly. A good start is to search for how to restore the master database:
http://www.google.com/search?btnG=1&q=site%3Asqlservercentral.com+Restore+Master
that will give you links back to SQL Server Central articles like the following:
http://www.sqlservercentral.com/Forums/FindPost490956.aspx
http://www.sqlservercentral.com/Forums/FindPost485250.aspx
Jonathan Kehayias | Principal Consultant | MCM: SQL Server 2008
My Blog | Twitter | MVP Profile
Training | Consulting | Become a SQLskills Insider
Troubleshooting SQL Server: A Guide for Accidental DBAs[/url]
January 5, 2009 at 9:27 am
Disk / array failure
Loss of Windows host
Loss of physical server
Network down, move to new location/network
User deletion of data
January 5, 2009 at 9:53 am
Meteor hits the server room.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
January 5, 2009 at 11:02 am
Data corruption
* Noel
January 5, 2009 at 11:44 am
Disgruntled employees delete your databases like what happened to:
They were an online blogging/community site for six years, and had no backups of their SQL Database, that collapsed over the holidays because the database was deleted.
Jonathan Kehayias | Principal Consultant | MCM: SQL Server 2008
My Blog | Twitter | MVP Profile
Training | Consulting | Become a SQLskills Insider
Troubleshooting SQL Server: A Guide for Accidental DBAs[/url]
January 5, 2009 at 12:03 pm
Jonathan Kehayias (1/5/2009)
They were an online blogging/community site for six years, and had no backups of their SQL Database
Now that's just stupid. As is their comment that mirroring (as in RAID 1) is a 'backup mechanism'
I do find it rather ironic that the Google Ads that I get when visiting are for an online backup company. (see attached)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
January 5, 2009 at 12:07 pm
I forget who posted it on Twitter first, but it was covered on slashdot a few days back. It is really kind of sad. I am torn about how to feel about. I kinda want to laugh, but I have made the no backup mistake once in my life and I know first hand that sinking feeling you get when you goto tape and there is nothing there. Mine wasn't production thankfully, but it was not a fun few days to say the least.
Jonathan Kehayias | Principal Consultant | MCM: SQL Server 2008
My Blog | Twitter | MVP Profile
Training | Consulting | Become a SQLskills Insider
Troubleshooting SQL Server: A Guide for Accidental DBAs[/url]
January 5, 2009 at 2:30 pm
GilaMonster (1/5/2009)
Meteor hits the server room.
Maybe meteors are a bigger threat for you, but for me I am more worried about the aircraft taking off and landing next to the building hosting our servers. :w00t:
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
January 5, 2009 at 2:33 pm
Jonathan Kehayias (1/5/2009)
I forget who posted it on Twitter first, but it was covered on slashdot a few days back. It is really kind of sad. I am torn about how to feel about. I kinda want to laugh, but I have made the no backup mistake once in my life and I know first hand that sinking feeling you get when you goto tape and there is nothing there. Mine wasn't production thankfully, but it was not a fun few days to say the least.
Someone else posted on Twitter that this isn't the first occurrence. They had something similar happen in 2006 and didn't learn from their mistake.
K. Brian Kelley
@kbriankelley
January 5, 2009 at 10:23 pm
mahesh.vsp (1/5/2009)
Hi Pals,Can anyone suggest few links on disaster recovery scenarios for SQL Server 2005.
Example : IF "master" database is corrupted what needs to be done.
.. so on
looking forward for more inputs!
Thank You.
You have to restore master database from backup,
you may run dbcc checkdb for repair database or u can rebuild master database.
January 5, 2009 at 10:31 pm
Thank You so much Guys.:)
January 5, 2009 at 10:32 pm
Thank You so much!
January 6, 2009 at 5:45 am
Jeffrey Williams (1/5/2009)
GilaMonster (1/5/2009)
Meteor hits the server room.Maybe meteors are a bigger threat for you, but for me I am more worried about the aircraft taking off and landing next to the building hosting our servers. :w00t:
😀 I just put that as a 'worst case'
Where I live, seismic events are a worry. The CBD of Johannesburg is undermined and there's always a worry that one of the old mining tunnels collapses and takes part of the city with it.
I'd also be rather worried about a runway near my server room.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 14 posts - 1 through 13 (of 13 total)
You must be logged in to reply to this topic. Login to reply