About a month ago I restored a data base that had been originally created in MSDE into a full version of SQL Server 2000. I thought that the size restriction would automatically be removed by putting it into the full version of SQL. I was wrong and about a week or so later the data base reached the 2GB size and needed attention. I received some assistance through Microsoft and they walked my client through the process of removing the size restriction. Since then everything has been OK.
Now I am doing something similar. My client has a data base that was originally created in MSDE. We upgraded them to SQL Express and the data base has now grown to 4GB which is the max that SQL Express allows.
We will be installing SQL for Workgroups this week.
My question is this. Is there a setting I must change inside the data base or in SQL for Workgroups that will allow the data base to grow beyond 4GB? We need to let it expand to whatever they need and I cant seem to find any documentation on whether or not I have to change a setting for this data base.
Thanks for your help. Jean
It's possible that you may need to change the autogrowth settings for the database. In Management Studio, right click the database, choose Properties, then go to the Files page. Check what's in the Autogrowth column for each file and verify that it's either set to "unrestricted growth", or restricted to a sufficiently large size. Looking at an Express Edition installation, it doesn't appear that a 4 GB autogrowth limit is selected by default, however. You should be able to load Developer Edition onto a test machine and play around with this a bit before you go live.|||Thank you David. I will take a look at that when we upgrade the customer. I am certain that is where I will find the settings. I appreciate your help. Jean
No comments:
Post a Comment