big sqlserver transaction log file
when create the sql server 2000 db, i have to define the File Growth Ratio say 10%.
however, one problem is that the size of the db grows so fast.
the actual db is only 3 mb but the transaction log file is 74mb
Used Data File Space : 3 (in MB)
Used Log File Space : 74 (in MB)
Allocated Data File Space : 100 (in MB)
Allocated Log File Space : 80 (in MB)
(control data data)
What does that mean?? does it mean i still have 97mb space available for my sql db? or just 23mb??
i tried to set the shrink schedule to reduce the file size, and now when i right click on the db and select properties, i'll see
the size: 76.13 mb
space available: 42.31 mb
:unsure:
don't really understand what's going here. how can i limit the size of the log file and should the shrink schedule does any help.
