Viewing 15 posts - 20,731 through 20,745 (of 49,552 total)
You can't put expressions in the calling of a procedure. Declare variables, set the variables to the results of the expressions, use the variables in the EXEC statement.
Also, 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
January 26, 2012 at 9:55 am
Sure, that's the best way to see what you're losing. Just bear in mind that if you try and access the damaged documents in the corrupt DB you'll get errors.
As...
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
January 26, 2012 at 9:39 am
Could be more, could be less. There are 17 LOB pages damaged (if I counted correctly), that's about all I can tell you for sure
With sharepoint you have no choice...
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
January 26, 2012 at 9:03 am
If you repair this you will lose probably 17 documents from the sharepoint site, no way to tell which ones and no way to fix this without losing that data....
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
January 26, 2012 at 8:44 am
Who knows. The cause of this is likely buried somewhere in the past.
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
January 26, 2012 at 8:41 am
Dev (1/26/2012)
May I ask how did you figure out it’s a SharePoint database?
CHECKDB found 0 allocation errors and 70 consistency errors in database 'WSS_Content_5ce5ed6d-52b4-4eb9-a134-45fb513127fb'.
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
January 26, 2012 at 8:36 am
bashiyam.ganesh (1/26/2012)
The backup also having the same issue, is there any way can I see which page is corrupted?
And earlier backups? Restore is just about the only safe way 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
January 26, 2012 at 8:36 am
I strongly recommend you restore from a clean backup since this is a Sharepoint DB. Repair could have very nasty consequences.
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
January 26, 2012 at 8:27 am
Yes, it's called proportional fill.
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
January 26, 2012 at 8:26 am
From simply having multiple files in Primary, no (unless you have several thousand).
From other things, sure. That DB's getting big so things like indexes, well performing SQL, stats, etc...
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
January 26, 2012 at 8:24 am
Ignacio A. Salom Rangel (1/26/2012)
Just remember that if you set the current file not to autogrowth, when it becomes full you will get all kind of errors
No it won't. There...
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
January 26, 2012 at 8:19 am
If you set it to not autogrow or set a max size, then correct. With 2 files in the same filegroup, one mostly empty one mostly full, SQL will write...
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
January 26, 2012 at 8:09 am
Please note the original thread is almost 2 years old.
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
January 26, 2012 at 8:07 am
Welsh Corgi (1/26/2012)
GilaMonster (1/26/2012)
The error implies there were. Did you check MSDB backup tables? Did you check the LSNs in the full and diff backup headers?
I'm sure that is what...
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
January 26, 2012 at 7:46 am
lorra (1/26/2012)
My understanding is that SQL Server will use the primary key index in order to optimize the nonclustered indexes
Nope. The primary key is totally irrelevant for anything to do...
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
January 26, 2012 at 7:37 am
Viewing 15 posts - 20,731 through 20,745 (of 49,552 total)