Viewing 15 posts - 8,161 through 8,175 (of 9,725 total)
Tom.Thomson (1/25/2010)
This response is directly to the editorial - I haven't read any of the other comments yet..... If you think that, you are crazy!...
Tom,
I understand...
January 26, 2010 at 6:50 am
I'm sure there are a lot of differences between your servers and mine, but this fix was a permanant fix for us. I've had it in affect for almost 2...
January 21, 2010 at 12:10 pm
Precaution and dropping / recreating your maintenance plan are your only two solutions for now.
January 21, 2010 at 5:52 am
Unless it's included in SP2 or the SP1 Hot Fix, no. We don't have it applied to our clustered servers.
Of course, the initial solution I posted worked for us, so...
January 21, 2010 at 5:50 am
mirde (1/15/2010)
January 18, 2010 at 6:07 am
Caveat - I am using Litespeed for my backup maint. plans.
However, I have had the same issue. If I delete a database *before* altering the plan, the plan no longer...
January 18, 2010 at 6:02 am
Now, see, I've never heard of xp_DirTree before now. And for a moment, I actually considered changing the code I had to use it.
And then you spoiled it with...
December 21, 2009 at 4:19 am
Ah, but your response gives me a lot more information than I had before. Now I know what to look for and how to reconsider the partitioning idea.
Thank you.
December 18, 2009 at 10:25 am
And the user db is on the same drive or a different drive? How much space does it have available to it and is its Autogrowth set to Unlimited?
Run the...
December 18, 2009 at 8:57 am
rew-370421 (12/17/2009)
The TempDB is configured for AUTOGROWTH and there is plenty of disk space. So it's unclear as to why TempDB might be the cause of this.
You said tempDB only...
December 18, 2009 at 4:45 am
The "single drive" is actually a SAN. It's either Raid 5 or Raid 1 + 0, but I'm betting on Raid 5.
The plan is to keep everything in the...
December 17, 2009 at 12:18 pm
Just remember that xp_cmdshell is off by default and you'll have to turn it on before you can use it in this manner.
December 17, 2009 at 11:35 am
OLTP database. The partition would be storing historical records, but apparently the end users like to do a lot of "inception to current" summary reports. (I just found out about...
December 17, 2009 at 11:34 am
rew-370421 (12/17/2009)
I'm still confused as to why I'm receiving this error when I see FREE Space in "FileGroup 4" it's complaining about as well as the TempDB database?
Sorry, forgot to...
December 17, 2009 at 10:03 am
1053MB is NOT MUCH when it comes to TempDB.
Understand that just because it's showing free right now, does not mean there's enough space to do what your transaction is attempting...
December 17, 2009 at 10:01 am
Viewing 15 posts - 8,161 through 8,175 (of 9,725 total)