Viewing 15 posts - 5,716 through 5,730 (of 9,715 total)
gmamata7 (6/17/2011)
Question: Is my backup procedure good enough to take backup of Production database?
Yes and no.
Yes, because it's taking your backups.
No, because to truly verify your backups, it's best to...
June 17, 2011 at 10:30 am
paul.knibbs (6/17/2011)
Brandie Tarvin (6/16/2011)
Notice the difference in the accuracy.
They look the same to me--0.000, 0.003 or 0.007 means 3 divisions in 1/100th of a second, which is 1/300th second accuracy....
June 17, 2011 at 10:26 am
GSquared (6/17/2011)
george sibbald (6/17/2011)
quick straw poll if you don't mind guys -how much access should developers have in a development environment?
As much as they need. Really, in a dev...
June 17, 2011 at 7:49 am
Jeff Moden (6/17/2011)
Brandie Tarvin (6/16/2011)
June 17, 2011 at 7:46 am
Jeff Moden (6/17/2011)
Brandie Tarvin (6/16/2011)
If you don't have an Identity, add it to the table.
I prefer a method which exploits the IDENTITY column, as well, but it's just not possible...
June 17, 2011 at 5:13 am
John Mitchell-245523 (6/17/2011)
Brandie, a full backup doesn't break the log chain, although a lost or corrupted log backup certainly would.
Oh, yes. And finding that bit of information out when you...
June 17, 2011 at 5:07 am
John,
Sorry. You are correct. A full backup doesn't usually break the log chain.
I suppose I should have just said "chain" without the "log" because I've seen people do...
June 17, 2011 at 5:04 am
Craig Farrell (6/17/2011)
Phil Parkin (6/17/2011)
Actually, I was wondering about that. Does that mean the problem is that she has to get a full blow version of SQL Server to get...
June 17, 2011 at 4:44 am
Glad we were able to help.
June 17, 2011 at 4:43 am
vaibhavraut88 (6/16/2011)
Great Job dude ur script works. but can u explain me that code.
Look up Common Table Expressions and Row_Number() in Books Online, or Google the phrases. There's a lot...
June 17, 2011 at 4:40 am
Sachin4all (6/16/2011)
I installed 2005 sp2 and got it fixed
Ahha! Ye ol' Microsoft Bugginess were the problem, were it?
That makes sense. Glad you got it fixed.
June 17, 2011 at 4:37 am
sqlnes (6/16/2011)
We have heavy IO on tempdb right now and the size of tempdb grow rapidly. ... Our programmers use temp table a lot.
Hey, be careful about this correlation.
Temp...
June 17, 2011 at 4:35 am
Since no one actually verified this for him:
hammad772001 (6/16/2011)
June 17, 2011 at 4:27 am
Craig Farrell (6/16/2011)
Brandie Tarvin (6/16/2011)
But the OP is having issues with SQL Express 2008.
Just re-went through the thread and we're on the 2k5 forum... where am I not seeing the...
June 17, 2011 at 4:22 am
Craig Farrell (6/16/2011)
I'd heard rumors of transactions and checkpoints not behaving nicely in 2k5, I'm going to need to explore a few other packages I'd expected to behave themselves.
I've had...
June 16, 2011 at 12:53 pm
Viewing 15 posts - 5,716 through 5,730 (of 9,715 total)