DBCC Timewarp

Question

DBCC Timewarp

Viewing 15 posts - 46 through 60 (of 158 total)

You must be logged in to reply to this topic. Login to reply

Michael Valentine Jones SSC Guru Points: 64818 More actions · Answer 1

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?

Lowell SSC Guru Points: 323518 More actions · Answer 2

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?

Lowell

--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

LutzM SSC Guru Points: 107049 More actions · Answer 3

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:

Lutz
A pessimist is an optimist with experience.

How to get fast answers to your question[/url]
How to post performance related questions[/url]
Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

SQLRNNR SSC Guru Points: 281334 More actions · Answer 4

george sibbald (2/8/2010)
CirquedeSQLeil (2/8/2010)
nigel. (2/8/2010)
george sibbald (2/8/2010)
Its possible if you have some of its poo.
Oh yeah, plenty of s*** round here :-). Gotta make sure I use the right sample, or could recreate something horrific.
One key ingredient has been left out. Hamster poo is pretty obvious. Swallow poo is critical to the success of your restore. Make sure it is an African Swallow.
Jason, not in this case, this is a hamster we are trying to recover. The hamster could end up corrupted.

Oh yes - good point. In that case, one should take care to maintain a distance of 137 parsecs, avoid any elderberries and keep all swallow guano far from the site. This should help the hamster recover nicely.

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

The Dixie Flatline SSC Guru Points: 53354 More actions · Answer 5

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.

__________________________________________________

Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills

john.arnott SSChampion Points: 11882 More actions · Answer 6

I have to laugh at all you Microsoft acolytes trying to master DBCC Time Warp.

If you'd been working with Oracle instead, you'd know that Ellison's minions realized the fully integrated electro-encephalagraphic interface for SPC (Space Time Continuum) control in January 2023. Parameters? PARAMETERS? I don't got to show you no stinkin' parameters..... Just imagine your solution and when it should have been implemented, and collect your check.

________________

Edited: 23 days from now @ 00:42 AM by john.arnott

The Dixie Flatline SSC Guru Points: 53354 More actions · Answer 7

No need to get testy, John. After all, this forum is intended to be a chronosynclastic infundibulum.

__________________________________________________

Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills

george sibbald SSC Guru Points: 104210 More actions · Answer 8

John, thats just perapatetic exogmatism.

At least SQL server is fully heterogenous with Oracles electro-encephalagraphic interface for SPC ( a cost extra I might add) simply by using the -T666 flag.

---------------------------------------------------------------------

john.arnott SSChampion Points: 11882 More actions · Answer 9

george sibbald (2/8/2010)
John, thats just perapatetic exogmatism.
At least SQL server is fully heterogenous with Oracles electro-encephalagraphic interface for SPC ( a cost extra I might add) simply by using the -T666 flag.

Yes. You remind me that for evaluation purposes one may invoke the Runymede option to open the EEI-for-SPC function set only for dates in 1066, CE. At least by using switch -T1066, MS made it easy to premember.

george sibbald SSC Guru Points: 104210 More actions · Answer 10

Also, in full production mode EEI-for-SPC produces so many dmp files in so many different space-time continuums that it requires 3 Oracle DBAs concentrating on it full time.

DBCC Timewarp can be run by a single DBA.

---------------------------------------------------------------------

Steve Jones - SSC Editor SSC Guru Points: 736494 More actions · Answer 11

Just starting to investigate this command. Does the setting of "cosmic string count" on the server have any effect?

john.arnott SSChampion Points: 11882 More actions · Answer 12

Steve Jones - Editor (2/8/2010)
Just starting to investigate this command. Does the setting of "cosmic string count" on the server have any effect?

Yes. It essentially determines the domain in the SPC where the server can participate. And that's the dirty little secret about the command. Although the string count itself is a simple part of your server settings, the actual reference data is stored in the binary orientation of intergalactic dust particles, the coordinates of which are closely guarded by MS and access rights to which will blow the SW licensing budget of all but the most flush of IT organizations.

The Dixie Flatline SSC Guru Points: 53354 More actions · Answer 13

Can someone give me a plain English explanation of why parameter 242 is designated as being either "dark matter approximate mass" OR "dimensionality (post M-String)" ??? What controls the context and frame of reference here?

__________________________________________________

Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills

Matt Miller (4) SSC Guru Points: 124210 More actions · Answer 14

(This answer was removed after its future question was previously deleted).

----------------------------------------------------------------------------------
Your lack of planning does not constitute an emergency on my part...unless you're my manager...or a director and above...or a really loud-spoken end-user..All right - what was my emergency again?

RBarryYoung SSC Guru Points: 143329 More actions · Answer 15

[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.

[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]