Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 177
  • Last Modified:

How do I Shrink a log file?

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
0
camoIT
Asked:
camoIT
  • 2
  • 2
  • 2
  • +1
1 Solution
 
zelron22Commented:
If you perform a full backup of the database the SQL logs should be purged.  How are you backing up the database?
0
 
camoITAuthor Commented:
We use Backup Exec 11d.  

Is there another method if I didnt have BE11d?  
0
 
PakaCommented:
You should be able to use the SQL 2005 backup tool (embedded in the GUI) to truncate the logs too.
0
Creating Active Directory Users from a Text File

If your organization has a need to mass-create AD user accounts, watch this video to see how its done without the need for scripting or other unnecessary complexities.

 
zelron22Commented:
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.
0
 
CompuzedCommented:
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.
0
 
PakaCommented:
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

0
 
camoITAuthor Commented:
Thanks a million this resolved my problem.  Thanks to all who helped me
0

Featured Post

Has Powershell sent you back into the Stone Age?

If managing Active Directory using Windows Powershell® is making you feel like you stepped back in time, you are not alone.  For nearly 20 years, AD admins around the world have used one tool for day-to-day AD management: Hyena. Discover why.

  • 2
  • 2
  • 2
  • +1
Tackle projects and never again get stuck behind a technical roadblock.
Join Now