Viewing 15 posts - 7,141 through 7,155 (of 8,416 total)
GilaMonster (9/8/2009)
There are bugs, they are rare. I believe Paul Randal talks about 99.9% of all corruptions he's seen are IO subsystem problems.
That's just a fancy way to say that...
September 8, 2009 at 4:50 am
sqlrunner (9/4/2009)
September 8, 2009 at 3:51 am
GilaMonster (9/8/2009)
Well, excluding bulk-logged operations in bulk-logged recovery model.
You make it sound as if backing up the log, switching to the BULK_LOGGED recovery model, performing minimally-logged operations (like an index...
September 8, 2009 at 3:35 am
A differential backup contains all the changes since the last full backup.
An incremental backup contains all the changes since the last incremental backup (or the full, if no incrementals have...
September 8, 2009 at 3:15 am
winston Smith (9/7/2009)
September 8, 2009 at 3:07 am
GilaMonster (9/8/2009)
Paul White (9/8/2009)
If no errors are reported after a stage, you know that the corruption occurs somewhere in the following log restores.
Log backups generally will only have corruption in...
September 8, 2009 at 3:03 am
Indianrock (9/7/2009)
September 8, 2009 at 2:54 am
Actually, I might have misread the question first time around - I thought you were asking what to do if you received the DBCC message after restoring the database from...
September 8, 2009 at 2:33 am
winston Smith (9/7/2009)
September 8, 2009 at 2:07 am
benyos (9/7/2009)
Assuming your inline comamnds are plain SQL or through exceptions when there are internal erros, you could simply use the built in mechanism in SQL 2005:
You should check XACT_STATE()...
September 7, 2009 at 11:48 pm
This really needs to be in a stored procedure, and you should convert the query to a SARGable form.
See my previous post.
September 7, 2009 at 10:25 pm
TheSQLGuru (9/7/2009)
BTW, are you going to PASS this year? Would love to meet you.
This is NOT an on-line dating service :laugh:
September 7, 2009 at 10:17 pm
September 7, 2009 at 9:52 pm
Bob Hovious (9/7/2009)
I think I will start referring to you as Emperor Paulpatine.
Truly, you do deserve your reputation as a monitor-killer.
I was enjoying that cup of coffee too 😎
September 7, 2009 at 8:38 pm
Bob Hovious (9/7/2009)
Many thanks, Paul.Grant, I liked this question, even though I got it wrong. 😉
You're most welcome.
I haven't answered the question yet - but once again the discussion...
September 7, 2009 at 8:35 pm
Viewing 15 posts - 7,141 through 7,155 (of 8,416 total)