InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comFri, 24 May 2013 05:11:08 GMT20http://www.sqlservercentral.com/Forums/Topic1208907-263-1.aspx[quote][b]David Conn (12/1/2011)[/b][hr]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.[/quote]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) ;-)Thu, 01 Dec 2011 18:03:46 GMTNinja's_RGR'ushttp://www.sqlservercentral.com/Forums/Topic1208907-263-1.aspx10 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.Thu, 01 Dec 2011 12:14:01 GMTDavid Connhttp://www.sqlservercentral.com/Forums/Topic1208907-263-1.aspx[quote][b]David Conn (11/30/2011)[/b][hr]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.[/quote]How much data did you lose?Thu, 01 Dec 2011 04:43:56 GMTNinja's_RGR'ushttp://www.sqlservercentral.com/Forums/Topic1208907-263-1.aspxI 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.Wed, 30 Nov 2011 23:38:15 GMTDavid Connhttp://www.sqlservercentral.com/Forums/Topic1208907-263-1.aspxThe 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.Tue, 22 Nov 2011 03:50:26 GMTJon-413357http://www.sqlservercentral.com/Forums/Topic1208907-263-1.aspxI've checked all of my servers and can't find any drives with a power switch!!Mon, 21 Nov 2011 15:51:30 GMTLon-860191http://www.sqlservercentral.com/Forums/Topic1208907-263-1.aspxOh 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. :-/Mon, 21 Nov 2011 08:27:12 GMTGilaMonsterhttp://www.sqlservercentral.com/Forums/Topic1208907-263-1.aspxYou 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.Mon, 21 Nov 2011 08:21:54 GMTGSquaredhttp://www.sqlservercentral.com/Forums/Topic1208907-263-1.aspxComments posted to this topic are about the item [B]<A HREF="/articles/Editorial/76977/">Helpful Advice?</A>[/B]Sun, 20 Nov 2011 03:33:00 GMTSteve Jones - SSC Editor