12-04-2010, 01:20 AM
You haven't enabled the autoshrink setting have you?
1. In Object Explorer, connect to an instance of the SQL Server Database Engine, and then expand that instance.
2. Expand the Databases, and then right-click the database that you want to shrink.
3. Point to Tasks > Shrink > Database.
4. Optionally, select the Reorganize files before releasing unused space check box. If selected, a value must be specified for Maximum free space in files after shrinking.
Selecting this option is the same as specifying a target_percent value when executing DBCC SHRINKDATABASE. Clearing this option is the same as executing DBCC SHRINKDATABASE using the TRUNCATEONLY option. TRUNCATEONLY reduces the file size without moving any data. By default, the option is cleared.
5. Enter the maximum percentage of free space to be left in the database files after the database has been shrunk (use numbers 0-99 since they are valid entries). This option is only available when Reorganize files before releasing unused space is selected, and click Ok.
The transaction log might be filling up too quickly, or staying far too large, which is why your database is large.
1. In Object Explorer, connect to an instance of the SQL Server Database Engine, and then expand that instance.
2. Expand the Databases, and then right-click the database that you want to shrink.
3. Point to Tasks > Shrink > Database.
4. Optionally, select the Reorganize files before releasing unused space check box. If selected, a value must be specified for Maximum free space in files after shrinking.
Selecting this option is the same as specifying a target_percent value when executing DBCC SHRINKDATABASE. Clearing this option is the same as executing DBCC SHRINKDATABASE using the TRUNCATEONLY option. TRUNCATEONLY reduces the file size without moving any data. By default, the option is cleared.
5. Enter the maximum percentage of free space to be left in the database files after the database has been shrunk (use numbers 0-99 since they are valid entries). This option is only available when Reorganize files before releasing unused space is selected, and click Ok.
The transaction log might be filling up too quickly, or staying far too large, which is why your database is large.