Viewing 15 posts - 16 through 30 (of 132 total)
I'm restoring now to a new database. I check its integrity as soon as I can.
May 8, 2015 at 8:28 am
Here's the results:
Msg 8909, Level 16, State 1, Line 1
Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 0 (type Unknown), page ID (1:1337094) contains...
May 8, 2015 at 7:54 am
I started the checkdb. It should take <10 minutes. I just had our sysadmins add another drive letter to this VM so I can restore the last good...
May 8, 2015 at 7:47 am
SSIS has it's own separate memory, it's a separate process.
Thanks for that. I always wondered but never knew for sure. Up until recently, all my SSIS packages...
January 7, 2015 at 12:07 pm
That's really interesting. There almost 500gb of free disk on the server so I couldn't imaging tempdb running out. But the first thing I did this morning was...
November 12, 2014 at 12:54 pm
The problem is definitely the SAN. I had 825 errors from this server last week. The SysAdmins are building me a new VM and I'm going to move...
November 12, 2014 at 11:35 am
I guess I mean: Wasn't I getting the Short Stack Dump because SQL Server was having trouble running the Checkdb, not that the Checkdb was reporting consistency errors? And...
October 28, 2014 at 8:25 am
I had several occurrences of this, DBCC Checkdb reporting errors that turned up false, run clean the next day. Then on one of runs reporting errors I found "Resource Monitor...
October 28, 2014 at 8:17 am
And that's me in the log stopping the Agent. Small server. Was trying to free resources for the DBCC to complete.
October 17, 2014 at 9:42 am
No. Just a couple of scheduled backups. Here's the Log. This is a test system, low activity. After the stack dump, a few backups and then...
October 17, 2014 at 9:37 am
Had the same problem once. I ended up creating an Excel "template" with row 1 having my column headers and row 2 having formatted sample data. In the...
June 13, 2014 at 1:44 pm
Also check the values of msdb.dbo.backupset.is_snapshot and/or msdb.dbo.backupset.is_copy_only for your database. Could be your VM backup software is taking a sql db snapshot as part of the server backup....
June 13, 2014 at 1:10 pm
Vendor system - I won't change their design. App was recently upgraded and our users had a streak of timeouts in the front end and were complaining. I...
February 19, 2014 at 1:22 pm
I guess your query uses buffer_descriptors joining with allocation_units views.
Exactly.
OK. Was wondering because the tables I always see, taking the most space, have no clustered indexes. ...
February 18, 2014 at 1:37 pm
I've only used a proxy when a vendor app wanted thier domain account (as opposed to my Agent's domain account) to run an SSIS package from an Agent job. ...
December 19, 2013 at 9:16 am
Viewing 15 posts - 16 through 30 (of 132 total)