Viewing 15 posts - 39,091 through 39,105 (of 49,552 total)
mikeandanne (5/14/2009)
They are trying to restore the log to rebulid the db from the transactions.
Can you elaborate?
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
May 14, 2009 at 2:59 pm
Please read through this - Managing Transaction Logs[/url]
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
May 14, 2009 at 2:59 pm
Please read through the article I linked. You're still missing the table definition (as a create table) and that sample data's going to be hard to use in it's current...
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
May 14, 2009 at 2:56 pm
Why are you rebuilding the log? What happened to the existing log file?
Two options.
1) Restore from last backup. Recommended
2) Hack the DB back into the server, do an emergency mode...
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
May 14, 2009 at 2:43 pm
Bob Hovious (5/14/2009)
On Qo'noS, none rise to the rank of Klingon Senior DBA except over the bloody bodies of their fallen predecessors.
And that's different from current-day corporates how?
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
May 14, 2009 at 2:32 pm
TcW_1978 (5/14/2009)
So it seems the table is not corrupted, back to square one...
Nope. No corruption.
What's the error messages that you're getting?
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
May 14, 2009 at 2:31 pm
Paul Randal (5/14/2009)
The sysindexes errors are corruptions in the statistics blobs - you should be able to get around those by dropping and recreating all your statistics.
Drop and recreate all...
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
May 14, 2009 at 2:28 pm
TcW_1978 (5/14/2009)
Is it possible that a single table is corrupted and not the entire database?
Yes, absolutely. That's the more common form of corruption, just a single page.
What's the error that...
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
May 14, 2009 at 11:45 am
I'll look at the plans later. Just one thing now. That's a very big clustered index. Clustered indexes should be as narrow as possible because they're included in every nonclustered...
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
May 14, 2009 at 11:29 am
Ok, two things.
1) This is not completely repairable.
2) You're going to lose data and you probably already lost a lot in the previous repair
I suspect (and will get a second...
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
May 14, 2009 at 10:59 am
Highly likely it's a statistics problem. If SQL estimates a small number of rows it's likely to use a loop join.
Please post query and exec plan (without hash join hint)
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
May 14, 2009 at 10:34 am
Vicki Peters (5/14/2009)
Awesome, that worked. Thank you!
Yup, but note that it does what Lowell and I already suggested. Create a new table, copy all the data over, recreate the constraints,...
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
May 14, 2009 at 10:31 am
Vicki Peters (5/14/2009)
I'd like to insert it in a place that makes sense.
Why? Order of columns in a table is quite irrelivent. All it affects is what you see in...
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
May 14, 2009 at 8:05 am
Looks like you may have some irreparable corruption there. Can you please run the following so that I can see exactly what errors remain. Please post the full results.
DBCC CHECKDB(<Database...
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
May 14, 2009 at 7:08 am
Well, on versions before 2008 there really weren't many options. Triggers, properly implemented, do auditing quite well.
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
May 14, 2009 at 6:52 am
Viewing 15 posts - 39,091 through 39,105 (of 49,552 total)