DBCC Timewarp
-
Bob Hovious (2/8/2010)
[h2]Urgent![/h2]Folks, I need serious help and fast! I have two cores on my system, so tried to use the "[font="Courier New"]-parallel[/font]" option in [font="Courier New"]DBCC Timewarp[/font], but something has gone seriously wrong. I don't think that "parallel" means what I thought it did.
That causes the implementer to experience sudden aging by several years.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events -
Bob Hovious (2/8/2010)
[h2]Urgent![/h2]Folks, I need serious help and fast! I have two cores on my system, so tried to use the "[font="Courier New"]-parallel[/font]" option in [font="Courier New"]DBCC Timewarp[/font], but something has gone seriously wrong. I don't think that "parallel" means what I thought it did.
The other side effect is as you have noticed. It causes split personality and impersonation syndrome which has been quantifiably displayed.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events -
I think the offspring of the thread is causing some problems with the Site. Anybody else notice some timewarp delays at SSC throughout the day today?
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events -
CirquedeSQLeil (2/8/2010)
Bob Hovious (2/8/2010)
[h2]Urgent![/h2]Folks, I need serious help and fast! I have two cores on my system, so tried to use the "[font="Courier New"]-parallel[/font]" option in [font="Courier New"]DBCC Timewarp[/font], but something has gone seriously wrong. I don't think that "parallel" means what I thought it did.
The other side effect is as you have noticed. It causes split personality and impersonation syndrome which has been quantifiably displayed.
No dude, you don't understand, I didn't do anything. This stuff is happening on its own, right in front of my eyes! I think that "Parallel" might mean "Parallel Universe".
Wait a sec, somethings happening again... OMG, hurry, it's getting worse!!!
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font] -
Oh sweet mercy..... Barry is really my own self from an alternative universe?!
I feel smarter already !!
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills -
Run away! Run away!
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events -
lmu92 (2/8/2010)
nigel. (2/8/2010)
My hamster just fell through a distortion in the space-time continuum. Is it possible to get him back using DBCC TIMEWARP. Please help, he was my best friend.Ooops!
Could you please specify your target time?
I guess you messed up one of the addtl. parameter 11 or 13 together with a typo in your space-time value, because all of a sudden something like a hamster materialiezed in my microwafe yesterday. Unfortuntely, I was just cooking some beef stroganoff at the same time. After a rather noisy "PLOPP" (I couldn't find any reason for until I read your post) the beef tasted a little strange and had some fluffy elements I didn't remember to have added... :sick:
Agggghhhh noooo!!!!!!
Oh well. Was that with rice?
-
CirquedeSQLeil (2/8/2010)
I think the offspring of the thread is causing some problems with the Site. Anybody else notice some timewarp delays at SSC throughout the day today?No, but I did see some next week.
-
The Dixie Flatline (2/8/2010)
Oh sweet mercy..... Barry is really my own self from an alternative universe?!I feel smarter already !!
Crap! My wife just called me "Bob"! That's not right, ... is it? OMG, I can't remember what my real name is supposed to be anymore!!! Please, somebody send help fast! ... :crazy:
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font] -
I have just come back from an interview where the interviewer asked me about DBCC timewarp and wanted me to describe the full syntax of all 137 required parameters (he wasn't even aware of the 255 optional ones !).
I told him I couldn't do that but I knew where to look it up (this thread basically).
I think he was trying to pump me for information as they had a corrupt database with no backups, even future ones.
Do you think I gave the right answer and was it professional of the interviewer to ask me a question about an undocumented procedure?
---------------------------------------------------------------------
-
Bob Hovious (2/9/2010)
The Dixie Flatline (2/8/2010)
Oh sweet mercy..... Barry is really my own self from an alternative universe?!I feel smarter already !!
Crap! My wife just called me "Bob"! That's not right, ... is it? OMG, I can't remember what my real name is supposed to be anymore!!! Please, somebody send help fast! ... :crazy:
Oh no! Oh no, oh no, ... Look what just appeared on my shoulder:
Why would you do this to yourself, Bob?!?! GAAAAAHHHH!!!!
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font] -
Lowell (2/8/2010)
you guys have show some great examples of using a future backup to fix todays data, but I've got a question along a similar vein:somehow I've forgotten to create any backups on the production database for the last two years. Now the boss wants to archive all the backups off site for disaster recovery.
Based on your wonderful examples, I was able to create a backup today based on a backup i was planning to do in a week or two after I got back from vacation; but now i need to create a history of backups that go BACK two years, so it looks like I was doing my job.
Can anyone help me with the syntax for that?
Just type it all in backwards. Works every time.
- 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
-
The Dixie Flatline (2/8/2010)
Michael Valentine Jones (2/8/2010)
Has anyone figured out the parameter sequence to restore a database that doesn’t exist from an alternate timeline where it would have existed if the development project hadn’t failed?Michael, some of the heavyweights may have better answers, but I've tried to do something similar to shortcut the development time cycle on a project. The problem is I don't know the correct parameters for any of the particular alternate timelines where the project has succeeded brilliantly. My first solution was a while loop that tried random parameters, but that proved too slow. Then I reread the Book of Moden and implemented a set-based solution using a tally table with from 1 to infinity rows. It's working much faster and wll probably produce a solution in the next 1100-1200 days, which will still be considerably faster than the development cycle would have been anyway.
In any event, I've now started to leave comments to my alternate selves in my code, just in case.
Lowell: I'm sure a variation of this might work for your purposes.
Merodach: Steve and I did a jump to the left and a step to the right in The Thread, yesterday.
Steve: So happy you approve.
Create a proc that calls Timewarp recursively and you can reduce that wait by an arbitrary amount.
- 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
-
GSquared (2/9/2010)
Lowell (2/8/2010)
you guys have show some great examples of using a future backup to fix todays data, but I've got a question along a similar vein:somehow I've forgotten to create any backups on the production database for the last two years. Now the boss wants to archive all the backups off site for disaster recovery.
Based on your wonderful examples, I was able to create a backup today based on a backup i was planning to do in a week or two after I got back from vacation; but now i need to create a history of backups that go BACK two years, so it looks like I was doing my job.
Can anyone help me with the syntax for that?
Just type it all in backwards. Works every time.
... but don't run it backwards, or else your backups will become restores, and your restores backups.
Alvin Ramard
Memphis PASS Chapter[/url]All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
-
hi guys 🙂
is there a full description or a white paper for this command ?
Viewing 15 posts - 61 through 75 (of 158 total)
You must be logged in to reply to this topic. Login to reply