<a href="http://g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_blank"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15220&wd=468&ht=60&pair=as" alt="i" width="468" height="60"/></a>
Log in
::
Register
::
Not logged in
Home
Tags
Articles
Editorials
Stairways
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Write for us
<a href="http://g.adspeed.net/ad.php?do=clk&zid=15491&wd=120&ht=300&pair=as" target="_top"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15491&wd=120&ht=300&pair=as" alt="i" width="120" height="300"/></a>
Recent Posts
Recent Posts
Popular Topics
Popular Topics
Home
Search
Members
Calendar
Who's On
Home
»
SQLServerCentral.com
»
Editorials
»
Helpful Advice?
Helpful Advice?
Rate Topic
Display Mode
Topic Options
Author
Message
Steve Jones - SSC Editor
Steve Jones - SSC Editor
Posted Sunday, November 20, 2011 3:33 AM
SSC-Dedicated
Group: Administrators
Last Login: Yesterday @ 9:03 PM
Points: 31,406,
Visits: 13,723
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
GSquared
GSquared
Posted Monday, November 21, 2011 8:21 AM
SSCoach
Group: General Forum Members
Last Login: Monday, May 06, 2013 1:09 PM
Points: 15,439,
Visits: 9,569
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
GilaMonster
GilaMonster
Posted Monday, November 21, 2011 8:27 AM
SSC-Dedicated
Group: General Forum Members
Last Login: Today @ 7:21 AM
Points: 37,660,
Visits: 29,911
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
Lon-860191
Lon-860191
Posted Monday, November 21, 2011 3:51 PM
Ten Centuries
Group: General Forum Members
Last Login: Monday, May 06, 2013 8:39 AM
Points: 1,045,
Visits: 218
I've checked all of my servers and can't find any drives with a power switch!!
Post #1209696
Jon-413357
Jon-413357
Posted Tuesday, November 22, 2011 3:50 AM
Forum Newbie
Group: General Forum Members
Last Login: Tuesday, April 09, 2013 8:06 AM
Points: 9,
Visits: 45
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
David Conn
David Conn
Posted Wednesday, November 30, 2011 11:38 PM
SSCommitted
Group: General Forum Members
Last Login: Yesterday @ 9:45 PM
Points: 1,685,
Visits: 646
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
Ninja's_RGR'us
Ninja's_RGR'us
Posted Thursday, December 01, 2011 4:43 AM
SSC-Insane
Group: General Forum Members
Last Login: Yesterday @ 10:55 PM
Points: 21,357,
Visits: 9,534
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
David Conn
David Conn
Posted Thursday, December 01, 2011 12:14 PM
SSCommitted
Group: General Forum Members
Last Login: Yesterday @ 9:45 PM
Points: 1,685,
Visits: 646
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
Ninja's_RGR'us
Ninja's_RGR'us
Posted Thursday, December 01, 2011 6:03 PM
SSC-Insane
Group: General Forum Members
Last Login: Yesterday @ 10:55 PM
Points: 21,357,
Visits: 9,534
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 »
Permissions
You
cannot
post new topics.
You
cannot
post topic replies.
You
cannot
post new polls.
You
cannot
post replies to polls.
You
cannot
edit your own topics.
You
cannot
delete your own topics.
You
cannot
edit other topics.
You
cannot
delete other topics.
You
cannot
edit your own posts.
You
cannot
edit other posts.
You
cannot
delete your own posts.
You
cannot
delete other posts.
You
cannot
post events.
You
cannot
edit your own events.
You
cannot
edit other events.
You
cannot
delete your own events.
You
cannot
delete other events.
You
cannot
send private messages.
You
cannot
send emails.
You
may
read topics.
You
cannot
rate topics.
You
cannot
vote within polls.
You
cannot
upload attachments.
You
may
download attachments.
You
cannot
post HTML code.
You
cannot
edit HTML code.
You
cannot
post IFCode.
You
cannot
post JavaScript.
You
cannot
post EmotIcons.
You
cannot
post or upload images.
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.
