General information
Forum:
Microsoft SQL Server
Category:
Database management
Yes, same model: Full.
I just make a DTS to copy all data from database B to another new database C and the final size of that database C is 532MB. It seems like the records which is deleted in data. B is not replaced with new data and waste space.
>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
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only