May 31, 2007 at 11:58 pm
hi guys,
i'm using sql server 2000 enterprise edition (with SP3) on windows advanced server 2000 (with SP4).
have you ever experienced trying to increase the size of the PRIMARY filegroup of your MSDB database but is not working? i tried doing it using enterprise manager and TSQL but is not working and it is not returning an error. only TEMPDB and MSDB behave this way. the other databases are working fine.
as a result of this, i was unable to add some more sql agent jobs.
what i did as a workaround is that i created another filegroup(SECONDARY) and made it the default filegroup but still, i can't create additional sql agent jobs.
do you have another workaround for this?
June 1, 2007 at 12:56 am
What is the error you are getting when you are adding new sql agent jobs?
Also check if autogrowth is checked or not.
I'm able to increase the size without any fail on sql server2000 enterprise edition sp4.
June 1, 2007 at 2:15 am
auto grow is checked. the actual error everytime i add a new sql job is:
"Could not allocate space for object '(SYSTEM table id: 2)' in database 'msdb' because the 'PRIMARY' filegroup is full.."
eventhough i created a SECONDARY file group and made it as the default file group, i'm still getting the same error.
it's okay now, i have a resolution...
1. i created a backup out of MSDB and restore it in a different database name.
2. i stopped sql service and copy over the physical files of the new DB in item1 to MSDB.
3. i started sql service and tried increasing the PRIMARY file manually and everything is good. it is now automatically growing...
thanks for your reply...
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply