Hi Folks
I have tried all the conventional means of shrinking a Database to reduce the database and Log size. Currently these are 102Mb and 38Mb respectively but use only about 20% of the file size for the DB and 5% for the Log.
The Truncate on Checkpoint option is turned on. There are NO open transactions as checked with:
DBCC OpenTran
I have tried:
DBCC ShrinkDatabse
DBCC ShrinkFile
Truncating the Log and doing a complete backup
Though these have work prefect for other databases on the SQL Server, nothing seems to work with this particular DB. Any suggestions are welcome
Thanks
AJ
I have tried all the conventional means of shrinking a Database to reduce the database and Log size. Currently these are 102Mb and 38Mb respectively but use only about 20% of the file size for the DB and 5% for the Log.
The Truncate on Checkpoint option is turned on. There are NO open transactions as checked with:
DBCC OpenTran
I have tried:
DBCC ShrinkDatabse
DBCC ShrinkFile
Truncating the Log and doing a complete backup
Though these have work prefect for other databases on the SQL Server, nothing seems to work with this particular DB. Any suggestions are welcome
Thanks
AJ