Viewing 15 posts - 30,481 through 30,495 (of 49,552 total)
Andrew van Zyl (9/21/2010)
Can you suggest a SQL Recovery tool to try?
No, I've never personally used one. One (I don' know name) that a colleague once tried didn't work at...
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
September 21, 2010 at 9:23 am
Ninja's_RGR'us (9/21/2010)
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
September 21, 2010 at 9:20 am
You are not going to like this.
The page that's damaged (page 16) is the first page in the table sysallocunits. Sysallocunits is the table that contains info on where every...
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
September 21, 2010 at 9:17 am
Alvin Ramard (9/21/2010)
Kit G (9/21/2010)
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
September 21, 2010 at 8:18 am
Martonius333 (9/21/2010)
No problems - I guess only way then would be via "Generate a very big script" and export all the objects // data etc?
For data I recommend bcp out.
Can...
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
September 21, 2010 at 8:11 am
Yup, guessed that from earlier posts. Still want to see all relevant error log entries.
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
September 21, 2010 at 8:08 am
Martonius333 (9/21/2010)
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
September 21, 2010 at 7:51 am
Please put it into emergency mode and leave it there. Then please look in the SQL error log for the messages I've asked for.
In my experience in cases like this,...
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
September 21, 2010 at 7:50 am
These may be of interest
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
September 21, 2010 at 7:36 am
456789psw (9/20/2010)
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
September 21, 2010 at 7:34 am
Andrew van Zyl (9/21/2010)
Hi Gail,Have done exactly as suggested in the link.
Database is attached, but in suspect mode.
This is what I did subsequently, errors included:
<snip>
Any suggestions?
Errr... There are reasons I...
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
September 21, 2010 at 7:33 am
You forgot to attribute some of those queries to the people who wrote them
What queries are using the indexes: http://www.sqlservercentral.com/Forums/FindPost966688.aspx Jonathan Kehayias
Missing indexes: http://blogs.msdn.com/b/bartd/archive/2007/07/19/are-you-using-sql-s-missing-index-dmvs.aspx Bart Duncan
Unused indexes: http://blogs.technet.com/b/vipulshah/archive/2007/12/04/finding-missing-indexes-and-unused-indexes-using-dmvs.aspx Vipul...
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
September 21, 2010 at 7:26 am
Here's the bad news. There's no way to get a copy (short of bcp OUT) without taking the DB offline. Take it offline and you may not get it back...
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
September 21, 2010 at 6:35 am
Nothing means that the log is being correctly reused. Maybe whatever caused the growth has gone away.
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
September 21, 2010 at 6:33 am
First things first.
Do not restart SQL!
Do not detach the database!
Do not reboot the server!
Do any of those and it's likely that the DB will come back recovery pending at best.
Is...
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
September 21, 2010 at 6:15 am
Viewing 15 posts - 30,481 through 30,495 (of 49,552 total)