SQLServerCentral / Discuss Content Posted by Steve Jones / Article Discussions / Article Discussions by Author / Restoring Features / Latest Posts

RE: Restoring Features

Iulian -207023 — Tue, 19 Jul 2011 05:37:57 GMT

Nice question, thank youRegards,Iulian

RE: Restoring Features

Britt Cluff — Mon, 18 Jul 2011 05:44:40 GMT

Good question. I guessed wrong as backup/restore can get very complicated.

RE: Restoring Features

Dhruvesh Shah — Fri, 15 Jul 2011 19:15:42 GMT

Awesome question & diagnostics

RE: Restoring Features

Ninja's_RGR'us — Fri, 15 Jul 2011 12:14:14 GMT

[quote][b]Tom.Thomson (7/15/2011)[/b][hr][quote][b]Ninja's_RGR'us (7/14/2011)[/b][hr][quote][b]SQLkiwi (7/14/2011)[/b][hr][quote][b]Richard Warr (7/14/2011)[/b][hr]Good question but haven't we seen it before?[/quote]I thought so too, though I can't find the previous question. So, an easy 'green tick' for me today, but only because it was a memory test :-)[/quote]+1 I've seen this from Steve in the last few months. Not 100% sure it was a question but it's high up there.[/quote]I'm sure we've seen it recently. But just to check, and in case it was something slightly different that I remembered, I went to the connect item. I was told I'd already voted for it, so I'm 100% sure I'd seen the connect item before.[/quote]Same here!

RE: Restoring Features

L' Eomot Inversé — Fri, 15 Jul 2011 11:45:48 GMT

[quote][b]Ninja's_RGR'us (7/14/2011)[/b][hr][quote][b]SQLkiwi (7/14/2011)[/b][hr][quote][b]Richard Warr (7/14/2011)[/b][hr]Good question but haven't we seen it before?[/quote]I thought so too, though I can't find the previous question. So, an easy 'green tick' for me today, but only because it was a memory test :-)[/quote]+1 I've seen this from Steve in the last few months. Not 100% sure it was a question but it's high up there.[/quote]I'm sure we've seen it recently. But just to check, and in case it was something slightly different that I remembered, I went to the connect item. I was told I'd already voted for it, so I'm 100% sure I'd seen the connect item before.

RE: Restoring Features

SanDroid — Thu, 14 Jul 2011 13:32:55 GMT

[quote][b]Ninja's_RGR'us (7/14/2011)[/b][hr][quote][b]SanDroid (7/14/2011)[/b][hr]Got it wrong because my experiance and M$ docs aparently do not match with that of the rest of the world. :-P Maybe I should start including MS Connect posts in all my research. ;-)Steve, didn't your last "SQL Server License version caused a Backup Failure" connect post get tabled becuase of the dificulty of finding space in the Backup file BOOT or Loader header for this information?I guess the right thing for M$ to do would be either to document how to do this without a failure or update the M$ SQL documentaion to match "$pecial" behavior that was so obviously tacked on.[/quote]That connect item is in the answer's explaination.[/quote]Thanks Ninja, I read the connect item listed last time this question (or very similar one) was posted , but not this time. That answers if we have seen this before or not. Either that or my ESPN is WORKIN'! :w00t:

RE: Restoring Features

Ninja's_RGR'us — Thu, 14 Jul 2011 13:27:39 GMT

[quote][b]SQLkiwi (7/14/2011)[/b][hr][quote][b]Richard Warr (7/14/2011)[/b][hr]Good question but haven't we seen it before?[/quote]I thought so too, though I can't find the previous question. So, an easy 'green tick' for me today, but only because it was a memory test :-)[/quote]+1 I've seen this from Steve in the last few months. Not 100% sure it was a question but it's high up there.

RE: Restoring Features

Paul White — Thu, 14 Jul 2011 13:21:37 GMT

[quote][b]Richard Warr (7/14/2011)[/b][hr]Good question but haven't we seen it before?[/quote]I thought so too, though I can't find the previous question. So, an easy 'green tick' for me today, but only because it was a memory test :-)

RE: Restoring Features

Ninja's_RGR'us — Thu, 14 Jul 2011 13:17:43 GMT

[quote][b]SanDroid (7/14/2011)[/b][hr]Got it wrong because my experiance and M$ docs aparently do not match with that of the rest of the world. :-P Maybe I should start including MS Connect posts in all my research. ;-)Steve, didn't your last "SQL Server License version caused a Backup Failure" connect post get tabled becuase of the dificulty of finding space in the Backup file BOOT or Loader header for this information?I guess the right thing for M$ to do would be either to document how to do this without a failure or update the M$ SQL documentaion to match "$pecial" behavior that was so obviously tacked on.[/quote]That connect item is in the answer's explaination.

RE: Restoring Features

SanDroid — Thu, 14 Jul 2011 12:45:29 GMT

Got it wrong because my experiance and M$ docs aparently do not match with that of the rest of the world. :-P Maybe I should start including MS Connect posts in all my research. ;-)Steve, didn't your last "SQL Server License version caused a Backup Failure" connect post get tabled becuase of the dificulty of finding space in the Backup file BOOT or Loader header for this information?I guess the right thing for M$ to do would be either to document how to do this without a failure or update the M$ SQL documentaion to match "$pecial" behavior that was so obviously tacked on.

RE: Restoring Features

Rose Bud — Thu, 14 Jul 2011 11:38:21 GMT

The category "Right There with Babe" is another baseball reference:George Herman Ruth, Jr. (February 6, 1895 – August 16, 1948), best known as "Babe" Ruth, was an American Major League baseball player from 1914–1935. Ruth's lifetime total of 714 home runs at his retirement in 1935.

RE: Restoring Features

Trey Staker — Thu, 14 Jul 2011 11:35:27 GMT

Guessed it, missed it and was disappointed that it works that way. Thanks for the question.

RE: Restoring Features

bitbucket-25253 — Thu, 14 Jul 2011 11:16:00 GMT

paul s-306273 Way back in the beginning, to make the site more attractive to those interested in Microsoft's SQL Server the founders decided to award points to the site users. 1 point for each forum posting, and additional points for answering the question of the day. Some one (Steve is the only one who knows whom) decided to add a touch by creating categories of points awarded and assigned fun, but descriptive names at various point levels. The latest listing that I could find is displayed below. To earn the title "Say Hey Kid" you have earned at least 661 points, through correctly answering QODs plus postings.[code="sql"]ForumName Threshold-------------------------------------------------- ---------------------------------------Newbie 0Grasshopper 10SSC Rookie 25Valued Member 50SSC Journeyman 75SSC Enthusiastic 100SSC Veteran 200Old Hand 300SSC Addicted 400Mr. or Mrs. 500 500SSChasing Mays 600Say Hey Kid 661Right There with Babe 714SCC Eights 800Ten Centuries 1000Default port 1433UDP Broadcaster 1434SSCommitted 1500SSCrazy 2000Hall of Fame 3000SSCarpal Tunnel 4000SSCertifiable 5000SSCrazy Eights 8000SSChampion 10000SSCoach 15001SSC-Insame 20000One Orange Chip 25000SSC-Dedicated 30000SSC-Forever 40000SSC Guru 50000[/code]

RE: Restoring Features

SQLRNNR — Thu, 14 Jul 2011 11:11:13 GMT

Thanks for the question.

RE: Restoring Features

codebyo — Thu, 14 Jul 2011 11:05:44 GMT

I got it right because I have seen this exact question before. Back then I haven't answered it correctly.I see how that can be problematic with large backups.Thanks for the question.Best regards,

RE: Restoring Features

KWymore — Thu, 14 Jul 2011 09:50:23 GMT

Nice question, got it wrong but I learned something today.

RE: Restoring Features

paul s-306273 — Thu, 14 Jul 2011 09:21:17 GMT

[quote][b]wware (7/14/2011)[/b][hr][quote][b]paul s-306273 (7/14/2011)[/b][hr]I see that I've become "[i]Say Hey Kid[/i]" today.What is that?[/quote]Willie Howard Mays, Jr. (born May 6, 1931) is an American professional baseball player, nicknamed "The Say Hey Kid." Many consider him to be the greatest all-around player of all time. He ended his career with 660 home runs.[/quote]Now I understand - thanks.PaulManchester, UK.

RE: Restoring Features

Rose Bud — Thu, 14 Jul 2011 08:36:21 GMT

[quote][b]paul s-306273 (7/14/2011)[/b][hr]I see that I've become "[i]Say Hey Kid[/i]" today.What is that?[/quote]Willie Howard Mays, Jr. (born May 6, 1931) is an American professional baseball player, nicknamed "The Say Hey Kid." Many consider him to be the greatest all-around player of all time. He ended his career with 660 home runs.

RE: Restoring Features

Cliff Jones — Thu, 14 Jul 2011 08:24:14 GMT

[quote][b]paul s-306273 (7/14/2011)[/b][hr]I see that I've become "[i]Say Hey Kid[/i]" today.What is that?[/quote]I suppose that means that you have more points than Willie Mays.

RE: Restoring Features

paul s-306273 — Thu, 14 Jul 2011 08:11:30 GMT

I see that I've become "[i]Say Hey Kid[/i]" today.What is that?

RE: Restoring Features

jeff.mason — Thu, 14 Jul 2011 08:00:30 GMT

Very good question.

RE: Restoring Features

sharath.chalamgari — Thu, 14 Jul 2011 07:53:17 GMT

learned something today from this Question. thaks to steav

RE: Restoring Features

paul s-306273 — Thu, 14 Jul 2011 06:08:56 GMT

One point for that Steve?

RE: Restoring Features

Richard Warr — Thu, 14 Jul 2011 03:55:09 GMT

Good question but haven't we seen it before?

RE: Restoring Features

Stewart "Arturius" Campbell — Thu, 14 Jul 2011 02:59:42 GMT

This has burned me in the past as well.thanks for the question, Steve.

RE: Restoring Features

Kwex — Thu, 14 Jul 2011 02:45:27 GMT

Nice question ... I got this one right from a past experience!Kwex.

RE: Restoring Features

Koen Verbeeck — Thu, 14 Jul 2011 00:24:30 GMT

Excellent question. I got it wrong, but I definately learned something. And it is very useful to know how the restore will fail.

RE: Restoring Features

rals — Wed, 13 Jul 2011 23:00:47 GMT

Nice Question and my guess is right today :) !!!

RE: Restoring Features

mohammed moinudheen — Wed, 13 Jul 2011 22:31:25 GMT

Nice question Steve, Thank you.

Restoring Features

Steve Jones - SSC Editor — Wed, 13 Jul 2011 22:19:35 GMT

Comments posted to this topic are about the item [B]Restoring Features[/B]