msdb running out of space 1

[swoodring]

Lately when I've been trying to save DTS packages which are stored in msdb I keep getting not enough disk space error. I check the db and it seems to be full. I've check the options and its set to autogrow at 1 mb at a time. Shouldn't it be growing for me so I can save it. Or is the size of the autogrow set too small? I'm using sql server 7.0

Stacy

 

[foxdev]

You can set both the AutoGrow and Restrict Filegrowth options at the same time. If Restrict Filegrowth is set to 100 Mb, then once the file reaches that size it will not grow any larger. Robert Bradley

http://www.foxdev.com/

Do you have too much money? Visit

http://www.agrainofhope.org

 

[swoodring]

MSDB is set as unrestricted file growth so thats not the problem. In the meantime I've gone in and increased the size myself. I now have about 350 MB free but am still getting error not enough disk space. I am a correct in that DTS are stored in MSDB. Correct? Any ideas on why I'm still getting this error?

 

[foxdev]

Hmmm...yes, its true that the DTS packages are stored in the MSDB database. I have two ideas:

1) How are you on TEMPDB space?
2) Do you have plenty of free space on the client machine (the one you are working on)?
Robert Bradley

http://www.foxdev.com/

Do you have too much money? Visit

http://www.agrainofhope.org

 

[swoodring]

Temp Db has 8 MB free and is set to autogrow by 10% with unrestricted file growth. On my machine my C is pratically maxed out but I do have room on my D drive which is where the sql directories are. Shouldn't it be saving it to the server anyways?

 

[swoodring]

actually I freed up a little space on my C drive and try saving it again and it worked. It must use some temp space on my C drive while its trying to save it to the server. I have plenty of space on D so I'm going to need to run Partition magic to move some from my D to my C drive.
Thanks for your help.