Viewing 15 posts - 31,561 through 31,575 (of 49,552 total)
Yup.
Once you've run the repair, just run checkDB with the no_infomsgs options again, to be sure it is all clean.
Have you done any root-cause analysis?
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
July 29, 2010 at 9:58 am
Gianluca Sartori (7/29/2010)
... it's by design, beacase the tables were initially loaded with NOLOGGING option
And people still ask for a way to run SQL transactions without any logging....
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
July 29, 2010 at 9:41 am
mdfaraz (7/28/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
July 29, 2010 at 9:38 am
mdfaraz (7/29/2010)
I updated my reply with bold..Couldn't get the red color to work!! 🙁
What's wrong with using the quote codes? To change colour, you need to wrap "" around the...
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
July 29, 2010 at 9:32 am
If you want to play...
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
July 29, 2010 at 9:08 am
That's not the full output of checkDB. The database-level summary line is missing.
For the query to ID the damaged row, does anything change if you add WITH (INDEX = 0)...
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
July 29, 2010 at 9:03 am
RichardDouglas (7/29/2010)
The reason for this is that the transaction log is no longer linked to a particular full backup
They never have been. Transaction log backups are linked to the previous...
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
July 29, 2010 at 8:57 am
Brandie Tarvin (7/29/2010)
GilaMonster (7/29/2010)
Results of test:....
If you're interested in repo:
....
-- open mdf in hex editor at this point and overwrite part of the first couple pages.
Is this what you...
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
July 29, 2010 at 8:54 am
GSquared (2/3/2009)
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
July 29, 2010 at 8:47 am
Paul White NZ (7/29/2010)
Tom.Thomson (7/29/2010)
Amazing, especially the one from someone who's apparently an MVP.
I'm sure we've all said dumb stuff at times, but reading that thread there seemed to be...
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
July 29, 2010 at 8:45 am
Paul White NZ (7/29/2010)
I've just never actually tried it with a *damaged* simple-recovery database, which is the only case I am not sure about.
Damaged is not going to...
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
July 29, 2010 at 8:42 am
Kwisatz78 (7/29/2010)
Can we go in at a page level to remove it?
Not unless you want a whole load more corruption errors. The chance that you could successfully edit the row...
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
July 29, 2010 at 8:28 am
Odd. Could be an effect of the other corruptions on the table.
Think I'm going to defer to Paul here. Paul, repair first (no backup) then see about the data purity...
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
July 29, 2010 at 8:16 am
As long as the new hard drive is physically attached to the server that's running SQL, yes. You can't, for example, put the files on to a network share.
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
July 29, 2010 at 5:27 am
Tom.Thomson (7/29/2010)
Amazing, especially the one from someone who's apparently an MVP.
My thoughts exactly. He is an MVP. I searched for his MVP profile on the microsoft site and he does...
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
July 29, 2010 at 5:24 am
Viewing 15 posts - 31,561 through 31,575 (of 49,552 total)