August 26, 2010 at 6:17 pm
GilaMonster (8/26/2010)
CirquedeSQLeil (8/26/2010)
716 (caffeine)Using a lot of that one tonight. Wait, it's morning already.
Already worked the 24 hour day and then breezed through the 12 hour night. That is efficient use of the clock.:hehe:
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
August 26, 2010 at 7:32 pm
CirquedeSQLeil (8/26/2010)
WayneS (8/26/2010)
CirquedeSQLeil (8/26/2010)
Alvin Ramard (8/26/2010)
CirquedeSQLeil (8/26/2010)
Well, we can see that Wayne has come into some more free time 😉I wonder which DBCC TimeWarp parameter value(s) he's using.
716 (caffeine)
1892 (morphine)
346 (HGH)
I guess I should have anticipated this strange twist of the thread... had me chuckling pretty good there!
I know one person that would be ecstatic if I had found all this time :crazy:
1?
I am stuck in a tossup between three choices to know which 1 that is:
1. Wife
2. yourSelf
3. OP (not in the forum sense or Ocean Pacific sense either)
OP. Wife and myself will be ecstatic when I find a job where I can actually go home at nights... which means even less time for OP.
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
August 27, 2010 at 5:17 am
WayneS (8/26/2010)
Stefan Krzywicki (8/26/2010)
On a side note, why busses? Why aren't people in these theoreticals brought up in too many meetings ever hit by taxis, trucks, private cars, trains, boats, airplanes, street vendor carts, horses, steamrollers or other construction equipment, trollies or subways?I've got a coworker that says "What's wrong with them getting fed up and leaving for a better job? Why do they always have to be killed?"
'round here, we prefer to say "What if So-n-so won the lottery and moved to Tahiti?" Has a much better connotation. @=)
August 27, 2010 at 5:36 am
GilaMonster (8/26/2010)
Trey Staker (8/26/2010)
Alvin Ramard (8/26/2010)
Q: How would you schedule DB backups to be able to do a point in time recovery?A: For example, weekly full backup, daily log backups, and hourly incrementals.
Interviewer: I think you have the last 2 reversed.
Interviewee: No, no, that's how you do it.
I actually went through an interview that was the exact opposite. The Interviewer swore that daily log backups and hourly incrementals were the way to go. I declined the position when it was offered to me.
Especially interesting seeing as SQL doesn't have incremental backups
They're working off of SQL 2000 (and prior) information. Lots of people I've met have misunderstood differentials to be the same as incrementals. Even though 2000 had both.
August 27, 2010 at 5:43 am
Brandie Tarvin (8/27/2010)
They're working off of SQL 2000 (and prior) information. ... Even though 2000 had both.
SQL 2000 didn't have incrementals. Just full, diff and log, like 2005+. I don't recall 7 having them either. Can't say about earlier versions.
http://technet.microsoft.com/en-gb/library/cc966495.aspx#E0LB0AA
Some people refer to log backups as incrementals (dunno if MS has ever used that term for them) because they only contain info since previous log backup. And yeah, the differential vs incremental catches a lot of people.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 27, 2010 at 5:50 am
Odd. I remember studying incremental backups when I took my SQL 2000 cert test. Maybe 2000 got rid of it and SQL 7 had it, but there were incremental backups in SQL Server at some point.
Where as differentials take changes since the last point of a full backup, incrementals would take changes since the last incremental backup, or the last full backup, depending on which was more recent. Which meant that you needed all the incrementals plus your full backup for a restore.
That's probably why MS got rid of it. Because it was just silly and unnecessary when you had differentials.
August 27, 2010 at 5:55 am
Brandie Tarvin (8/27/2010)
Odd. I remember studying incremental backups when I took my SQL 2000 cert test.
Me too, when I did the Windows server portion of the MCDBA. NTBackup has full, diff and incrementals
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 27, 2010 at 6:15 am
Maybe, but ISTR that it was a reference to SQL Server, not the OS. Because there were questions on how to restore SQL Server with various different backup plans.
AhHA! I'm not imagining this. Other people have noted the SQL Server incremental backup too.
Interestingly enough, though, this Simple Talk article[/url] references incremental as a transactional log backup, which I thought Incremental referred to the data file, not the log file.
Wow. Googling these terms shows this to be a debate that has lasted a long time. Now I'm going to have to go back to my study materials and double-check myself. There's an article in this debate. Or at least a blog post.
August 27, 2010 at 7:04 am
GilaMonster (8/27/2010)
Brandie Tarvin (8/27/2010)
They're working off of SQL 2000 (and prior) information. ... Even though 2000 had both.SQL 2000 didn't have incrementals. Just full, diff and log, like 2005+. I don't recall 7 having them either. Can't say about earlier versions.
http://technet.microsoft.com/en-gb/library/cc966495.aspx#E0LB0AA
Some people refer to log backups as incrementals (dunno if MS has ever used that term for them) because they only contain info since previous log backup. And yeah, the differential vs incremental catches a lot of people.
Differential vs incremental, that was my mistake, but I don't care because I'm not a DBA. 😀
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]
August 27, 2010 at 7:09 am
Alvin Ramard (8/27/2010)
Differential vs incremental, that was my mistake, but I don't care because I'm not a DBA. 😀
ACK! We've been invaded! There's one of those non-DBA types on this thread. Quick, someone get me some incense and holy water so I can exorcise the forums.
DBCC Timewarp him out of existence!
@=)
August 27, 2010 at 7:12 am
Brandie Tarvin (8/27/2010)
Alvin Ramard (8/27/2010)
Differential vs incremental, that was my mistake, but I don't care because I'm not a DBA. 😀ACK! We've been invaded! There's one of those non-DBA types on this thread. Quick, someone get me some incense and holy water so I can exorcise the forums.
DBCC Timewarp him out of existence!
@=)
Incense & Holy Water, no, no, no, Shotguns with silver bullets, stakes, big honkin' knives and lots & lots of fire. Let's do this right!
Sorry, just finished the second Monster Hunter International book. Lovin' me some Larry Correia[/url].
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
August 27, 2010 at 7:13 am
Brandie Tarvin (8/27/2010)
Alvin Ramard (8/27/2010)
Differential vs incremental, that was my mistake, but I don't care because I'm not a DBA. 😀ACK! We've been invaded! There's one of those non-DBA types on this thread. Quick, someone get me some incense and holy water so I can exorcise the forums.
DBCC Timewarp him out of existence!
@=)
I resemble that remark, but for entertainment's sake, go ahead, squish the chipmunk. Careful though, he's quick, and I hear tell he bites.
---------------------------------------------------------
How best to post your question[/url]
How to post performance problems[/url]
Tally Table:What it is and how it replaces a loop[/url]
"stewsterl 80804 (10/16/2009)I guess when you stop and try to understand the solution provided you not only learn, but save yourself some headaches when you need to make any slight changes."
August 27, 2010 at 7:13 am
Brandie Tarvin (8/27/2010)
Alvin Ramard (8/27/2010)
Differential vs incremental, that was my mistake, but I don't care because I'm not a DBA. 😀ACK! We've been invaded! There's one of those non-DBA types on this thread. Quick, someone get me some incense and holy water so I can exorcise the forums.
DBCC Timewarp him out of existence!
@=)
Oh dear...
Non-DBA types aren't supposed to be here?
I... um...
I just finished implementing backups for the first time, does that count? Can I get honorary DBA status for the purposes of reading this thread?
--------------------------------------
When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
--------------------------------------
It’s unpleasantly like being drunk.
What’s so unpleasant about being drunk?
You ask a glass of water. -- Douglas Adams
August 27, 2010 at 7:15 am
Brandie Tarvin (8/27/2010)
Alvin Ramard (8/27/2010)
Differential vs incremental, that was my mistake, but I don't care because I'm not a DBA. 😀ACK! We've been invaded! There's one of those non-DBA types on this thread. Quick, someone get me some incense and holy water so I can exorcise the forums.
DBCC Timewarp him out of existence!
@=)
Relax. I'm one of those good SQL developers. I've looked after a few SQL Servers in the past and I'm one of those developers that have worked to help the DBAs, including automating some of their tasks and rewriting other people's poorly written procedures.
Unlike other developers, I can actually hear the DBAs when they talk. 😛
Edit:
I forgot to say, I've also kept a few DBAs rear ends out of hot water. Wish I had a dollar for each time I've had to do their work. Thank God not all DBAs were created equal. Nice to see that some are more equal than others. 😀
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]
August 27, 2010 at 7:25 am
Brandie Tarvin (8/27/2010)
ACK! We've been invaded! There's one of those non-DBA types on this thread.
Shush!
He's not the only one 😛
Far away is close at hand in the images of elsewhere.
Anon.
Viewing 15 posts - 17,791 through 17,805 (of 66,712 total)
You must be logged in to reply to this topic. Login to reply