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

Helpful Advice? Expand / Collapse
Author
Message
Posted Sunday, November 20, 2011 3:33 AM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Yesterday @ 8:41 PM
Points: 31,080, Visits: 15,525
Comments posted to this topic are about the item Helpful Advice?






Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #1208907
Posted Monday, November 21, 2011 8:21 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Friday, June 27, 2014 12:43 PM
Points: 13,872, Visits: 9,596
You mean you don't just automatically do all of those things every day?

I have a job that runs them automatically every day, right in the middle of peak business hours, when our websites and databases are under maximum load. That insures the best results!

Especially the bit about repeatedly cycling the power on the SAN. That's critical!

...

Meanwhile, back in reality, I've had to restore a database and move on, but that was before I actually knew about point-in-time options on DR.

I once had to take a database offline and rebuild a copy of it from backups, but I brought it up to present-time without any data loss. That was to handle a locked SPID that just simply would not finish rolling back a non-existent transaction, which was blocking a few database level operations that were needed.


- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread

"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
Post #1209328
Posted Monday, November 21, 2011 8:27 AM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: General Forum Members
Last Login: Today @ 1:11 AM
Points: 39,968, Visits: 36,328
Oh don't even get me started.

The latest thing that really gets me is people writing blog posts recommending things like this (or deleting transaction logs, detaching suspect databases, etc, etc) then they moderate comments and never approve comments that explain how terrible that advice really is. So people run across those blog posts and see only good comments. Wonderful. :-/



Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #1209334
Posted Monday, November 21, 2011 3:51 PM
UDP Broadcaster

UDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP Broadcaster

Group: General Forum Members
Last Login: Tuesday, September 2, 2014 11:51 AM
Points: 1,442, Visits: 254
I've checked all of my servers and can't find any drives with a power switch!!
Post #1209696
Posted Tuesday, November 22, 2011 3:50 AM


Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Yesterday @ 2:32 AM
Points: 11, Visits: 62
The guy that said "Just rebuild your transaction log..." maybe meant "recreate the transaction log" in order to have less than 50 VLFs. Maybe dbas from other countries sometimes mix up terms like rebuild or recreate?

My advice (and I hope this is a better advice :-p):
Know exactly when, why and what you are doing, so you may know the outcome/implications before you start.
Post #1209968
Posted Wednesday, November 30, 2011 11:38 PM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Wednesday, August 27, 2014 2:20 PM
Points: 2,136, Visits: 870
I had to run with the "Allow Data Loss" once. It was the only option left after it was determined that the Backups were rubbish. It was a 3TB Database and it took 8 days to run.

Needless to say, many lessons learned from this exercise.
Post #1214363
Posted Thursday, December 1, 2011 4:43 AM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Monday, September 22, 2014 6:13 AM
Points: 20,578, Visits: 9,618
David Conn (11/30/2011)
I had to run with the "Allow Data Loss" once. It was the only option left after it was determined that the Backups were rubbish. It was a 3TB Database and it took 8 days to run.

Needless to say, many lessons learned from this exercise.


How much data did you lose?
Post #1214509
Posted Thursday, December 1, 2011 12:14 PM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Wednesday, August 27, 2014 2:20 PM
Points: 2,136, Visits: 870
10 Pages.

worse part after the time it took was not knowing what I'd lost. The only upside is that it's a Data Warehouse and in percentage terms this is a small amount of data.
Post #1214905
Posted Thursday, December 1, 2011 6:03 PM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Monday, September 22, 2014 6:13 AM
Points: 20,578, Visits: 9,618
David Conn (12/1/2011)
10 Pages.

worse part after the time it took was not knowing what I'd lost. The only upside is that it's a Data Warehouse and in percentage terms this is a small amount of data.


On a narrow sales table you can pack a couple $100 millions in sales with the right sort of products (like higer end cars or machinery)
Post #1215083
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse