Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Sql 2000, Database don't have available space Expand / Collapse
Author
Message
Posted Thursday, November 6, 2008 10:29 PM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Thursday, October 16, 2014 6:03 AM
Points: 1,065, Visits: 3,028
Hi,

Past five years back ,Some one has created one database in sql server 2000, so i noted this database properites as follows

status - Normal
owner -sa
date created - 2/3/2002
size -4654.12 mb
space available -0.00 mb
no.of user - 10

And database datafile properites file growth
In Megabytes - 50
restrict file growth - 4200

So what i want , need to be increase space available this database, please help me how to change space available?

I had tried and default setting for automatically grow file, By precent 10 and Unrestricted file growth but it was not hope. still space available 0.00 MB and database does not changed in change space available.

Post #598671
Posted Friday, November 7, 2008 12:57 PM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Thursday, May 22, 2014 7:04 AM
Points: 1,688, Visits: 8,766
Where exactly you are checking for space usage:
Taskpad, thru Command or ?

MJ
Post #599243
Posted Friday, November 7, 2008 1:20 PM
Right there with Babe

Right there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with Babe

Group: General Forum Members
Last Login: Thursday, October 16, 2014 12:19 AM
Points: 748, Visits: 901
try by running below query:

DBCC updateusage 'DBNAme'

check the properties

Thanks

Regards


Thanks and Regards!!

Raghavender Chavva
Post #599259
Posted Saturday, November 8, 2008 1:40 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Thursday, October 16, 2014 6:03 AM
Points: 1,065, Visits: 3,028
Thanks Raghavender,

After executing dbcc updateusages (0), database really changed space available.

Post #599402
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse