Hi to all,

I'm trying to increase my space allocated for my db and its not working... First off I have it checked "unrestricted file growth"...
Is it possible that there is a max that I can have...

Thanking you in advance...

Rino

Are both your Data Files and Transact Logs set to unrestricted growth?

--Stole this from a moderator

I will only tell you how to do it, not do it for you.
Unless, of course, you want to hire me to do work for you.

Yes both my data files and logs are set to unrestricted...
I'm trying to increase the size and its not working...
Is it possible that there is a max I can have for my DB...

In SQL Server Exrpess (MSDE) you are restricted to a 2GB database size. As far as I know SQL Server 2000 has no limit on the amount of space you can use for your database's. One of the resident SQL Gurus may be able to help you better.

--Stole this from a moderator

I will only tell you how to do it, not do it for you.
Unless, of course, you want to hire me to do work for you.

There actually is a limit on database size: it's 1,048,516 Terrabytes.

The log file is limited to 4TB in size.

One could argue that with limits like those, there really is no limit, as Doug suggests...

Jeff Mason
Custom Apps, Inc.
www.custom-apps.com

Hi..
     Just give a look to ur hardisk space...see if it is full or there is some quota on to it....