Reduce .mdf File

Legacy Poster

• January 22, 2013 13:11

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 !

0

• 

  Domingo Rodriguez

  Moderator

  ★ BarTender Hero ★

  • January 24, 2013 11:52
  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
• 

  Legacy Poster

  ★ BarTender Hero ★

  • January 25, 2013 08:23
  problem solved. thanks for your help.

  0

Please sign in to leave a comment.