ACCPAC Log File

[erprider]

Hi Guys

we have only 1 year data transaction in Accpac SQL LDF=30GB and MDF=17GD after running the Shrink log file query in SQL now my LDF=29 GB and MDF=16.4 GB

Is there any way to remove log files?
My harddisk is gettig full now .

Please suggest me

 

[Jay Converse]

Change the recovery model to Simple, then shrink the database.

 

[erprider]

Thnks for reply

Recovery model? will you please tell me ? how to do that

 

[Jay Converse]

Google it.

 

[ettienne]

LOL seriously???
SQL database properties, options, recovery model.

 

[DjangMan]

This can happen when you are rebuilding indexes as well.

 

[erprider]

Thank you very indeed ettinne its already recovery model in simple only.
yes Seriously nothing wrong or shame in the world to know an unknown things.

 

[Jay Converse]

If your recovery model is already Simple, then you need to right-click/Tasks/Shrink your database.

 

[erprider]

I done it as well. significantly 1 GB from 30 GB only reduced moreover

i ran query like

EXEC sp_detach_db @dbname = 'TRDAT';
EXEC sp_attach_single_file_db @dbname = 'TRDAT',
@physname = N'D:\SQLData\TRDAT.mdf';

but my question is cant we reduced the space more than 1 GB?

 

[erprider]

Okay. if i delete company and recreate the company and load the dump database
does it make any sense?

 

[ettienne]

Your log file should shrink to under 1MB if done correctly.

 

[Jay Converse]

It won't shrink below 1 Gb because whoever created the database set a default size of 1 Gb. After you Dbump, delete the database completely from SQL Studio, recreate it with a small log, then Dbload.

 

[erprider]

Thank you tuba2007 & ettienne