Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

The Nightmare Contest Expand / Collapse
Author
Message
Posted Thursday, September 16, 2004 4:10 PM
SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Friday, May 18, 2007 3:36 PM
Points: 10,039, Visits: 1
Comments posted to this topic are about the content posted at http://www.sqlservercentral.com/columnists/SOwners/then
Post #137493
Posted Friday, September 17, 2004 1:33 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Monday, August 18, 2014 1:30 AM
Points: 2,898, Visits: 1,795

I thought the contest was supposed to be SQL Server specific.

If I had known it was more general I could have told a few stories that would have made your hair stand on end!



LinkedIn Profile
Newbie on www.simple-talk.com
Post #137530
Posted Friday, September 17, 2004 8:34 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, July 12, 2013 11:40 PM
Points: 9, Visits: 136

I'd just like to know how it is possible to "turn off transaction logging", like was mentioned in the Valentines Day scenario. I wasn't aware that this could be done other than during bulk load operations.

Thanks,

James




Post #137590
Posted Friday, September 17, 2004 9:06 AM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Thursday, August 9, 2007 1:24 PM
Points: 507, Visits: 1
"Bad Vibrations" got my vote simply because this is a real unavoidable nightmare and can happen to any of us at any time. Many of the others were really the result of either bad judgement, bad planning, bad management decisions, or just plain rookie DBA inexperience. In any event they are all "preventable" in my opinion with a little planning, coordination, and forethought. But having multiple drives go down on you at one time I have experienced myself and I can tell you first hand, this is not only a unavoidable "nightmare", it is a long one too!


Post #137603
Posted Friday, September 17, 2004 9:11 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Monday, August 18, 2014 1:30 AM
Points: 2,898, Visits: 1,795

You can't turn it off, but you can set the transaction log to truncate on checkpoint.  This is the same as "Simple" recovery mode.



LinkedIn Profile
Newbie on www.simple-talk.com
Post #137604
Posted Friday, September 17, 2004 9:53 AM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Thursday, August 9, 2007 1:24 PM
Points: 507, Visits: 1
Exactly right and for any manager to insist that important high volume production databases run in "Simple" recovery mode is just sheer lunacy. That very preventable "nightmare" only happened simply because a moron(s) were running the show over there.


Post #137622
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse