We help IT Professionals succeed at work.

We've partnered with Certified Experts, Carl Webster and Richard Faulkner, to bring you a podcast all about Citrix Workspace, moving to the cloud, and analytics & intelligence. Episode 2 coming soon!Listen Now

x

How do I Shrink a log file?

Medium Priority
194 Views
Last Modified: 2012-06-21
We are using Great Plains 7.5 and 10.  There is an error message that the Log file is full for the database.  The error says to backup the log file to free up some space..

Does anyone have some steps for me to take?  Thanks
Comment
Watch Question

Commented:
If you perform a full backup of the database the SQL logs should be purged.  How are you backing up the database?

Author

Commented:
We use Backup Exec 11d.  

Is there another method if I didnt have BE11d?  

Commented:
You should be able to use the SQL 2005 backup tool (embedded in the GUI) to truncate the logs too.

Commented:
Do you have the Backup Exec SQL agent?  If you do, there's a setting in the job setup for truncating logs.  If you don't have the SQL Agent, then unless you're doing a separate backup through SQL (as per Paka) to file so Backup Exec can back that up, then you're not backing up your SQL database.

Commented:
I have seen a similar situation in sql itself.  are you running the sql managmenet studio and doing backups that way?  maybe you are need even aware of it.  But the default of SQL recovery model seems always to be "FULL" and this results in huge transacton logs.....on the advice of my database suppliers, this has been set to "SIMPLE" , and it results in a file size 1/10 of what they were....its a huge difference....
Not sure if that is what you are looking for, but it might help you out.
Commented:
Here's a pretty good thread on the topic of how to backup SQL 2005 without BackupExec:
http://social.msdn.microsoft.com/Forums/en-US/sqlexpress/thread/95750bdf-fcb1-45bf-9247-d7c0e1b9c8d2/

You should be able to backup the database (and truncate the logs as a result) by using either a SQL 2005 command line or a free downloadable GUI named "SQL Server Management Studio Express".  You can download the GUI at:
http://www.microsoft.com/downloads/details.aspx?familyid=C243A5AE-4BD1-4E3D-94B8-5A0F62BF7796&displaylang=en

Not the solution you were looking for? Getting a personalized solution is easy.

Ask the Experts

Author

Commented:
Thanks a million this resolved my problem.  Thanks to all who helped me
Access more of Experts Exchange with a free account
Thanks for using Experts Exchange.

Create a free account to continue.

Limited access with a free account allows you to:

  • View three pieces of content (articles, solutions, posts, and videos)
  • Ask the experts questions (counted toward content limit)
  • Customize your dashboard and profile

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.