SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Helpful Advice?


Helpful Advice?

Author
Message
Steve Jones
Steve Jones
SSC Guru
SSC Guru (64K reputation)SSC Guru (64K reputation)SSC Guru (64K reputation)SSC Guru (64K reputation)SSC Guru (64K reputation)SSC Guru (64K reputation)SSC Guru (64K reputation)SSC Guru (64K reputation)

Group: Administrators
Points: 64263 Visits: 19117
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
My Blog: www.voiceofthedba.com
GSquared
GSquared
SSC-Insane
SSC-Insane (24K reputation)SSC-Insane (24K reputation)SSC-Insane (24K reputation)SSC-Insane (24K reputation)SSC-Insane (24K reputation)SSC-Insane (24K reputation)SSC-Insane (24K reputation)SSC-Insane (24K reputation)

Group: General Forum Members
Points: 24057 Visits: 9730
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
GilaMonster
GilaMonster
SSC Guru
SSC Guru (89K reputation)SSC Guru (89K reputation)SSC Guru (89K reputation)SSC Guru (89K reputation)SSC Guru (89K reputation)SSC Guru (89K reputation)SSC Guru (89K reputation)SSC Guru (89K reputation)

Group: General Forum Members
Points: 89127 Visits: 45284
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, MVP, M.Sc (Comp Sci)
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


Lon-860191
Lon-860191
SSCommitted
SSCommitted (1.9K reputation)SSCommitted (1.9K reputation)SSCommitted (1.9K reputation)SSCommitted (1.9K reputation)SSCommitted (1.9K reputation)SSCommitted (1.9K reputation)SSCommitted (1.9K reputation)SSCommitted (1.9K reputation)

Group: General Forum Members
Points: 1895 Visits: 278
I've checked all of my servers and can't find any drives with a power switch!!
JonnoJ
JonnoJ
SSC Rookie
SSC Rookie (29 reputation)SSC Rookie (29 reputation)SSC Rookie (29 reputation)SSC Rookie (29 reputation)SSC Rookie (29 reputation)SSC Rookie (29 reputation)SSC Rookie (29 reputation)SSC Rookie (29 reputation)

Group: General Forum Members
Points: 29 Visits: 146
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.
David Conn
David Conn
Hall of Fame
Hall of Fame (3.2K reputation)Hall of Fame (3.2K reputation)Hall of Fame (3.2K reputation)Hall of Fame (3.2K reputation)Hall of Fame (3.2K reputation)Hall of Fame (3.2K reputation)Hall of Fame (3.2K reputation)Hall of Fame (3.2K reputation)

Group: General Forum Members
Points: 3165 Visits: 1152
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.
Ninja's_RGR'us
Ninja's_RGR'us
One Orange Chip
One Orange Chip (29K reputation)One Orange Chip (29K reputation)One Orange Chip (29K reputation)One Orange Chip (29K reputation)One Orange Chip (29K reputation)One Orange Chip (29K reputation)One Orange Chip (29K reputation)One Orange Chip (29K reputation)

Group: General Forum Members
Points: 29649 Visits: 9671
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?
David Conn
David Conn
Hall of Fame
Hall of Fame (3.2K reputation)Hall of Fame (3.2K reputation)Hall of Fame (3.2K reputation)Hall of Fame (3.2K reputation)Hall of Fame (3.2K reputation)Hall of Fame (3.2K reputation)Hall of Fame (3.2K reputation)Hall of Fame (3.2K reputation)

Group: General Forum Members
Points: 3165 Visits: 1152
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.
Ninja's_RGR'us
Ninja's_RGR'us
One Orange Chip
One Orange Chip (29K reputation)One Orange Chip (29K reputation)One Orange Chip (29K reputation)One Orange Chip (29K reputation)One Orange Chip (29K reputation)One Orange Chip (29K reputation)One Orange Chip (29K reputation)One Orange Chip (29K reputation)

Group: General Forum Members
Points: 29649 Visits: 9671
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) ;-)
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