January 26, 2006 at 8:35 am
Hello there!
FYI, I am quite new to SQL Server, so please bear with me.
Problem:
Due to heavy processing I have a tempdb database that is growing very large and is using up all the disk space on one of my drives. Would it be ok to temporarily add a secondary data file to the tempdb database? I am saying temporarily because the drive I would be adding the secondary data file to is connected to our NAS and needs to be disconnected soon. This means I would have to delete the secondary data file come that time. Is it ok to do this?
Your assistance is greatly appreciated.
Brandt
January 26, 2006 at 8:48 am
Brandt,
Here's one of those times when the standard "the answer you're looking for is in BOL" is probably the best answer. But I don't want you to think I'm not trying to help. Type in tempdb in the Index tab of BOL, when you click that you will see a category for Expanding a Database. I read through the topic and I believe the answer you're looking for is there. Although I've never done what your asking for, from what I read I think you can do it. It looks like the only caveat is you have to add the file to the default file group, you can't create a user file group for tempdb. Hope this helps and good luck. Let me know how this turns out.
Mark
January 27, 2006 at 3:52 am
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply