I've tried just about every answer I've found here on E-E with no success.
Here's the statistics:
Under DATA FILES:
SQL 2000 Server Enterprise edition
Autogrowth is set to 10 percent.
Autoshrink is checked.
Auto update statistics is checked.
Auto create statistics is checked.
We have run DBCC SHRINKDATABASE('database', TRUNCATEONLY)
We have run DBCC SHRINKFILE
We have set a Maintenance Plan to shrink and truncate.
We have done all of this to no avail. The databases continue to grow huge. We have one that has 41% free and will not relenquish the empty space back to the OS. We shrunk it originally from 48 GB back down to 4.5 GB last week by exporting the actual data to another DB and today it measures at 8.6 GB. That is NOT good. Any help would be greatly appreciated.
I agree with aneeshattingal that it might be the .ldf rather than the .mdf.
if that is the case, you simply need to implement a regular transaction log backup (every 30 minutes for example, or even shorter),
Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!
Everyone has problem when going to load data into Data warehouse (EDW). They all need to confirm that data quality is good but they don't no how to proceed.
Microsoft has provided new task within SSIS 2008 called "Data Profiler Task". It solve th…
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.