Reduce .mdf File Follow

0
Avatar
Legacy Poster

Hello to all ,

I have the follow problem .
My database in SQL for Bartender is almost 25Gb. I want to reduce the .mdf file.
Although I delete almost all data from tables the size is not reduced.

Thanks in advance !

2 comments

0
Avatar
Domingo Rodriguez
Moderator
Comment actions Permalink

Hello,

1.- First of all, please check if database maintenance has been enabled in the BarTender System Database Setup. You would verify this via the "Administer > Log Setup > Database Log" dialog in BarTender, by pressing the "Setup..." button and now selecting the "Maintenance" tab.

2.- You can use SQL Server Management Studio to produce a report indicating which tables in the database consume the most disk space.

In Management Studio:

Right-click on the database in the left-hand panel (Object Explorer).
Select "Reports->Standard Reports->Disk Usage" by "Top Tables".
This will produce the Report shown in screenshot: SQLDiskUsageReport.

Now export this report:
Right-click in the report you just generated.
Select "Export->Excel". See screenshot: SQLDiskUsageExport.

You can attach this file to this topic or contact our support personnel at
http://www.bartenderbarcodesoftware.com/label-software/technical-support.aspx#contact

3.- Alternatively, you can try shrinking the database in Management Studio using DBCC SHRINKDATABASE:
http://msdn.microsoft.com/en-us/library/ms190488%28v=sql.90%29.aspx
0
Avatar
Legacy Poster
Comment actions Permalink

problem solved. thanks for your help.

Please sign in to leave a comment.