Viewing 15 posts - 12,121 through 12,135 (of 49,562 total)
Wait. Do not restart SQL (the roll back will just continue with the DB unavailable). Check what the shrink process is waiting for.
August 14, 2013 at 5:07 am
Do not kill the process from Windows. There's an MSDN blog somewhere (will find when I get home if you like) that discusses what can happen in that case and...
August 14, 2013 at 5:07 am
Why are you partitioning? What's the intended goal?
August 14, 2013 at 5:00 am
If you want to drop an index at the subscriber, go to the subscriber and drop the index. Make sure that you don't adversely affect the subscriber's workload by doing...
August 14, 2013 at 4:58 am
Unless the database is in full recovery and there was a full backup taken at some point prior to the delete, there won't be anything in the log to analyse.
August 14, 2013 at 4:52 am
Please post table definition, index definitions and execution plan as per http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
August 14, 2013 at 12:46 am
That's how the index rebuild is executed behind the scenes
August 13, 2013 at 2:23 pm
Possibly related to this
August 13, 2013 at 1:38 pm
Why is the log growing? Logs should reach a steady spot where they don't grow any further, so what is causing your log to grow continuously?
August 13, 2013 at 9:48 am
Did you read the articles?
Any suggestions on exactly what specifically (since the articles explain log reuse and reasons why it might not be reused)?
August 13, 2013 at 9:39 am
If you have this problem, open a case with CSS. Data purity errors should not ever happen in the system tables.
August 13, 2013 at 9:38 am
Unless you have a really good reason otherwise, leave min server memory at default. 14.25GB is a little high on a 16 GB box. I'd usually start at 12...
August 13, 2013 at 9:35 am
HildaJ (8/13/2013)
However, if I removed this option how am I suppose to repair any errors if found? I guess manually?
By restoring a clean backup. Repair is usually a...
August 13, 2013 at 9:35 am
ctrlb (8/13/2013)
I do not believe it's uncorrectable corruption. http://support.microsoft.com/kb/923247 shows how to fix the error.
That support article explains how to fix the error in user tables. The table in question...
August 13, 2013 at 9:09 am
Let me guess, the index is 4 pages in size (at the leaf level)?
August 13, 2013 at 8:29 am
Viewing 15 posts - 12,121 through 12,135 (of 49,562 total)