SQL Server Database Backup - Trans. Log
Printed From: Web Wiz Forums
Category: Web Wiz Web App Support Forums
Forum Name: Web Wiz Forums
Forum Description: Support forum for Web Wiz Forums application.
URL: https://forums.webwiz.net/forum_posts.asp?TID=14179
Printed Date: 12 April 2026 at 12:51pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com
Topic: SQL Server Database Backup - Trans. Log
Posted By: NeutralizeR
Subject: SQL Server Database Backup - Trans. Log
Date Posted: 09 March 2005 at 8:53pm
|
 ------------- http://www.MsXLabs.com"> 
|
Replies:
Posted By: WebWiz-Bruce
Date Posted: 10 March 2005 at 4:49am
|
You need to put the recovery model for the SQL Server database onto simple. This should also help speed things up. ------------- https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting |
Posted By: NeutralizeR
Date Posted: 10 March 2005 at 1:08pm
|
 It's already set to simple...
How can i reduce the transaction log file size to the old one? (50mb)
Can i delete it ?  ------------- http://www.MsXLabs.com">
|
Posted By: michael
Date Posted: 10 March 2005 at 1:52pm
|
You can do a backup log with truncate only to get it to it's smallest factor, having it set to simple iirc should keep it small after that. ------------- http://baumannphoto.com" rel="nofollow - Blog | http://mpgtracker.com" rel="nofollow - MPG Tracker |
Posted By: NeutralizeR
Date Posted: 10 March 2005 at 1:56pm
|
Can you tell me how to do it step by step ?
I'm not familiar with SQL Server...  ------------- http://www.MsXLabs.com">
|
Posted By: NeutralizeR
Date Posted: 11 March 2005 at 3:41pm
|
I connect to my sql server database via client...
I can increase the file sizes but i can't decrease any of them...
My host takes backup of my database file (38mb, not including the transaction log) regulary...
Transaction log file size is 250 mb, as i said, i can't decrease it's size...
Is it really a problem ?
Taking backup of the real database file is enough ?
What do you offer for me ? I'm very concerned about my forum.
I've only one problem at the moment... Active Topics...
It's working for some time... Then it stops(only yesterday's posts)... Then it's working again...
I've tried changing LCID, resetting vs... but no success...
Thank you for the support... ------------- http://www.MsXLabs.com">
|