Home    Forums    Feature Requests    Beta Issues    SysAid Resources    Documentation    Support
Hello Guest,  Login   
        
DOWNLOAD FREE EDITION
    
     Recent Topics    Hottest Topics    Online Members    Member Listing    Advanced Search
Sysaid_log.ldf file in SQL growing out of control  XML
Forum Index » SysAid Installation & Beyond
 
Author Message
[Post New]09/09/2008 07:53:48
    Subject: Sysaid_log.ldf file in SQL growing out of control
[Up]
SyroTech
SysAider

SysAider from release 5.1 United States
Joined: 17/06/2008
Messages: 3
Offline
I need to know how to manage the size of the Sysaid_log.ldf file in SQL. Each time I free up drive space it grows to fill it and causes the system to generate low disk space messages. This also causes users to get a "Service is temporarily unavailable" message after logging into Sysaid. My current file size is 106.5 gig which seems excessive to me for the amount of info we have in the database. Any help would be appreciated. Thanks.
[Post New]09/09/2008 08:23:41
    Subject: Re:Sysaid_log.ldf file in SQL growing out of control
[Up]
Madmucho
SysAider


SysAider from release 5.5 Czech Republic
Joined: 20/06/2008
Messages: 10
Offline
You must backup you transaction log, after backup log is shrinkt
If you dont want in point recovery, you database recovery model can be set to simple and transaction log dont grow.

If you want shrink forcly you transaction log you can use folowing t-sql commands on your database

USE yourdata
GO
DBCC SHRINKFILE(yourdata_log, 2)
GO
BACKUP LOG yourdata WITH TRUNCATE_ONLY
GO
DBCC SHRINKFILE(yourdata_log, 2)

Space will be imidietly free.
I recommend do full backup after this procedure.
[Post New]09/09/2008 09:48:14
    Subject: Sysaid_log.ldf file in SQL growing out of control
[Up]
Haim
SysAid Wiz

Joined: 15/04/2008
Messages: 2449
Offline
Hello SyroTech

You can also right click the database in the management console, the go to tasks > shrink > database.
Then go to shrink > files, and choose the log file.

Best regards.
Haim
Pushing IT forward
[Post New]09/09/2008 10:03:15
    Subject: Re:Sysaid_log.ldf file in SQL growing out of control
[Up]
SyroTech
SysAider

SysAider from release 5.1 United States
Joined: 17/06/2008
Messages: 3
Offline
Yes, that worked very well. I shrank it down to 50gig and turned off the autogrow option. Everyone is now able to log into Sysaid again. Thanks.
[Post New]20/10/2010 03:38:48
    Subject: Re:Sysaid_log.ldf file in SQL growing out of control
[Up]
HansT
SysAider

SysAider from release 6 Netherlands
Joined: 13/10/2009
Messages: 35
Offline
I have the same problem here but shrinking the file won't release much space. Moving to another place on the server is not an option.

How can i reduce the log file size? (50Gb)

Using MS SQL 2005

This message was edited 1 time. Last update was at 20/10/2010 03:43:17
Forum Index » SysAid Installation & Beyond
Go to:   
Help Desk Software
Free Help Desk Software
Free Asset Management Software
SysAid Helpdesk Software
Web Based Help Desk Software
SysAid Help Desk Forum
General IT Discussion Forum
SysAid CSS Customer Service Software
Customer Support Software
    SysAid Technologies Ltd.
   Toll-Free phone center (U.S.): 1-800-686-7047
   Offices - U.S.617-231-0124
   Israel:+972-3-533-3675
   Email:helpdesk@sysaid.com
   Optimized by SEO Israel
   SysAid logos and other SysAid Technologies marks
   are trademarks or registered trademarks of
   SysAid Technologies Ltd.
   All Rights Reserved by SysAid Technologies Ltd.
   2002-2011 		   Live Support Hours
   07:00 AM - 09:30 PM (UK)
   03:00 AM - 05:30 PM (EDT)

   We provide worldwide services, and we do our best
   to match the working times of customers from
   different time zones.

   SysAid Help Desk Software and Asset Management Software
Privacy Policy © Terms Of Use