196 reputation
7
bio website google.com
location Tampa, FL
age 31
visits member for 1 year, 10 months
seen Oct 29 at 15:14

Nov
9
awarded  Popular Question
Feb
24
revised Getting “Attempt to fetch logical page in database” error when running query
added 193 characters in body
Feb
24
comment Getting “Attempt to fetch logical page in database” error when running query
@AaronBertrand it was a clustered index. Not all queries fail like if I just do select top 5 * from 'table' that will work. I haven't looked at DBCC PAGE. I googled that and it looks like I need a filenum and pagenum but I don't know which ones to look at. I did run dbcc page(7, 1, 8687634, 3) and got Msg 0, Level 11, State 0, Line 0 A severe error occurred on the current command. The results, if any, should be discarded.
Feb
24
comment Getting “Attempt to fetch logical page in database” error when running query
@Kin the msg is 605, level 21, state 3, line 1. I have SP1 right now but I'm downloading SP2.
Feb
24
revised Getting “Attempt to fetch logical page in database” error when running query
added 397 characters in body
Feb
24
asked Getting “Attempt to fetch logical page in database” error when running query
Dec
6
comment sql server 2008 r2 DBCC checktable error
@Edward Dortland I don't think the merge caused the corruption but I think some how the index got corrupted. The merge in the log just let me know what table to look at for the problem. The database is only read by users and written to by automated processes which I stopped for the check so, for me, I think I'm ok without single user check
Dec
4
awarded  Critic
Dec
3
comment sql server 2008 r2 DBCC checktable error
I think this did the trick. I reran DBCC CHECKTABLE after deleting the index and it reported no error.
Dec
3
accepted sql server 2008 r2 DBCC checktable error
Dec
3
awarded  Editor
Dec
3
revised sql server 2008 r2 DBCC checktable error
reran DBCC checktable and included the results.
Dec
3
accepted How to add additional hard drive(s) to existing database
Dec
3
asked sql server 2008 r2 DBCC checktable error
Apr
3
awarded  Supporter
Apr
3
comment How to add additional hard drive(s) to existing database
On your first point, what factors should go in to the decision between making a new filegroup vs just adding one or more files to an existing filegroup? Also, assuming I go with the new filegroup what is the difference between primary and secondary?
Apr
3
asked How to add additional hard drive(s) to existing database
Mar
7
awarded  Autobiographer
Jan
22
awarded  Scholar
Jan
22
accepted Why don't SQL Server queries use more than 7MB/sec of disk I/O