Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
MSDE DB size go up fast
Message
From
14/10/2005 06:42:05
Cristian Tenea
Aquila Part Prod Com
Ploiesti, Romania
 
 
To
14/10/2005 06:14:50
Jon Neale
Bond International Software
Wootton Bassett, United Kingdom
General information
Forum:
Microsoft SQL Server
Category:
Database management
Miscellaneous
Thread ID:
01059046
Message ID:
01059070
Views:
12
Yes, same recovery model: full.

>OK, the other thing I can think of is to check the recovery model are they both the same?
>
>
>>The free space in each database is ~3MB
>>
>>>Hi,
>>>
>>>Not 100% sure on this but when you create a database you can allocate the amount of space it takes up. So for example database A may have been allocated 1000MB with a 10% growth which means it allocates 1000MB straight off and then whenever it gets near that limit it automatically grows, so even with no records in, it would still show up as 1000MB. With Database B it may have been initally allocated more space than Database A.
>>>
>>>Check out the properties through Enterprise Manager if you can also check out DBCC SHRINKFILE or DBCC SHRINKDATABASE in BOL (I never remember which is the right one).
>>>
>>>Jon
>>>
>>>>Hi,
>>>>
>>>>Is there a problem with MSDE in terms of space allocation? I have 2 databases on MSDE and somenthig is wrong :
>>>>
>>>>database A has average double more records than B and size is 1067MB
>>>>database B has 2022MB and identical structure with A
>>>>
>>>>in database B there are more trafic than A - insert, updates, deletes
>>>>
>>>>What to do to shrink database at normal size?
>>>>
>>>>Thanks in advance.
Previous
Reply
Map
View

Click here to load this message in the networking platform