Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Disaster In The Real World - #2


Disaster In The Real World - #2

Author
Message
Andy Warren
Andy Warren
SSCertifiable
SSCertifiable (8K reputation)SSCertifiable (8K reputation)SSCertifiable (8K reputation)SSCertifiable (8K reputation)SSCertifiable (8K reputation)SSCertifiable (8K reputation)SSCertifiable (8K reputation)SSCertifiable (8K reputation)

Group: Moderators
Points: 7968 Visits: 2708
Comments posted to this topic are about the content posted at http://www.sqlservercentral.com/columnists/awarren/disasterintherealworld2.asp>http://www.sqlservercentral.com/columnists/awarren/disasterintherealworld2.asp

Andy
SQLAndy - My Blog!
Connect with me on LinkedIn
Follow me on Twitter
Jim P.
Jim P.
Right there with Babe
Right there with Babe (725 reputation)Right there with Babe (725 reputation)Right there with Babe (725 reputation)Right there with Babe (725 reputation)Right there with Babe (725 reputation)Right there with Babe (725 reputation)Right there with Babe (725 reputation)Right there with Babe (725 reputation)

Group: General Forum Members
Points: 725 Visits: 2215
The one thing I've done a lot is is created a scheduled task based off the sp_help_revlogin SP. It dumps the data to disk every 8 hours. Then the file is replicated to another server.

In a different job, I also had a script to create the restore scripts as well. That ran on a regular basis as well.

I also create my maintenance plans, etc by standardized scripts as well.

Having the logins with the right SIDs and the and the SQL backups, it allows me to not worry about recovering the system database and just do a fresh install of SQL Server. Then I worry about the user databases.



----------------
Jim P.

A little bit of this and a little byte of that can cause bloatware.
bitbucket-25253
bitbucket-25253
SSCertifiable
SSCertifiable (6.2K reputation)SSCertifiable (6.2K reputation)SSCertifiable (6.2K reputation)SSCertifiable (6.2K reputation)SSCertifiable (6.2K reputation)SSCertifiable (6.2K reputation)SSCertifiable (6.2K reputation)SSCertifiable (6.2K reputation)

Group: General Forum Members
Points: 6237 Visits: 25280
gloing73 (12/15/2012)
very good website:

===== http://www.globalmarket.name// =====

The website wholesale for many kinds of fashion shoes, like the nike, jordan, prada, also including the jeans, shirts, bags, hat and the decorations.

WE ACCEPT CREDIT CARD /WESTERN UNION PAYMENT
YOU MUST NOT MISS IT!!!
;-)


This particular post in this forum reported as SPAM

If everything seems to be going well, you have obviously overlooked something.

Ron

Please help us, help you -before posting a question please read

Before posting a performance problem please read
mtassin
mtassin
SSCarpal Tunnel
SSCarpal Tunnel (4.3K reputation)SSCarpal Tunnel (4.3K reputation)SSCarpal Tunnel (4.3K reputation)SSCarpal Tunnel (4.3K reputation)SSCarpal Tunnel (4.3K reputation)SSCarpal Tunnel (4.3K reputation)SSCarpal Tunnel (4.3K reputation)SSCarpal Tunnel (4.3K reputation)

Group: General Forum Members
Points: 4295 Visits: 72513
Hey Andy,

Just to be sure I read this right...

Win2k, SQL2k? In 2012?

Wow... makes me glad that management lets me upgrade to newer stuff than that!



--Mark Tassin
MCITP - SQL Server DBA
Proud member of the Anti-RBAR alliance.
For help with Performance click this link
For tips on how to post your problems
jonathan.d.myers
jonathan.d.myers
SSC Rookie
SSC Rookie (28 reputation)SSC Rookie (28 reputation)SSC Rookie (28 reputation)SSC Rookie (28 reputation)SSC Rookie (28 reputation)SSC Rookie (28 reputation)SSC Rookie (28 reputation)SSC Rookie (28 reputation)

Group: General Forum Members
Points: 28 Visits: 359
Hi, Andy,
I'd read your initial article a couple times to ensure I understood the chain of events and the timing of the issues. I've ran into a similar situation within the last year, and wanted to compare notes after the holiday. I'm uncertain whether your event was preventable, but we've determined ours was.

Firstly though, can you confirm your environment specs? We're most likely not comparing apples to apples, as we're running Windows 2k8 and SQL 2k5, currently, with a plan to skip 2k8 for 2012. In one case far in my past, the simultaneous outage for Exchange and SQL were caused by a single system issue, as the business had been stingy on funding a separate server for each. A simple drive fill caused by a mislocated tempdb caused the system failure. In the recent past, the issue was caused by and unscheduled & uncommunicated security alteration from the separate AD group in the company. In your case, it sounds more like a specific OS registry corruption on the Exchange server, and a separate but coincidental total failure of your RAID5 drive configuration for the SQL server.

Ignoring the mail server issue for a moment, was there monitoring for drive failure within your SQL RAID configuration? In addition, does your SQL instance use the Exchange server as the SMTP destination for any server alerts thru DBMail? Perhaps it wasn't as much of a coincidence after all.

I look forward to your comments in response. Hopefully, an alteration to the current recovery standards will help minimize recovery times in case of another event.

Cheers!
Jonathan
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search