Web Wiz Support and Community Forums : SQL Server Database Backup - Trans. Log https://forums.webwiz.net/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Sun, 12 Apr 2026 17:23:26 +0000 Fri, 11 Mar 2005 15:41:55 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.08 360 https://forums.webwiz.net/RSS_post_feed.asp?TID=14179 <![CDATA[Web Wiz Support and Community Forums]]> https://forums.webwiz.net/forum_images/web_wiz_forums.png https://forums.webwiz.net/ <![CDATA[SQL Server Database Backup - Trans. Log : I connect to my sql server database...]]> https://forums.webwiz.net/sql-server-database-backup-trans-log_topic14179_post78602.html#78602 Author: NeutralizeR
Subject: 14179
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...Embarrassed
]]> Fri, 11 Mar 2005 15:41:55 +0000 https://forums.webwiz.net/sql-server-database-backup-trans-log_topic14179_post78602.html#78602 <![CDATA[SQL Server Database Backup - Trans. Log : Can you tell me how to do it step...]]> https://forums.webwiz.net/sql-server-database-backup-trans-log_topic14179_post78526.html#78526 Author: NeutralizeR
Subject: 14179
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...Embarrassed
]]> Thu, 10 Mar 2005 13:56:09 +0000 https://forums.webwiz.net/sql-server-database-backup-trans-log_topic14179_post78526.html#78526 <![CDATA[SQL Server Database Backup - Trans. Log : You can do a backup log with truncate...]]> https://forums.webwiz.net/sql-server-database-backup-trans-log_topic14179_post78525.html#78525 Author: michael
Subject: 14179
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.

]]> Thu, 10 Mar 2005 13:52:07 +0000 https://forums.webwiz.net/sql-server-database-backup-trans-log_topic14179_post78525.html#78525 <![CDATA[SQL Server Database Backup - Trans. Log : It&#039;s already set to...]]> https://forums.webwiz.net/sql-server-database-backup-trans-log_topic14179_post78521.html#78521 Author: NeutralizeR
Subject: 14179
Posted: 10 March 2005 at 1:08pm

Picture 3

Picture 4
 
It's already set to simple...
 
How can i reduce the transaction log file size to the old one? (50mb)
 
Can i delete it ? Tongue
]]> Thu, 10 Mar 2005 13:08:09 +0000 https://forums.webwiz.net/sql-server-database-backup-trans-log_topic14179_post78521.html#78521 <![CDATA[SQL Server Database Backup - Trans. Log : You need to put the recovery model...]]> https://forums.webwiz.net/sql-server-database-backup-trans-log_topic14179_post78495.html#78495 Author: WebWiz-Bruce
Subject: 14179
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.
]]> Thu, 10 Mar 2005 04:49:23 +0000 https://forums.webwiz.net/sql-server-database-backup-trans-log_topic14179_post78495.html#78495 <![CDATA[SQL Server Database Backup - Trans. Log : ]]> https://forums.webwiz.net/sql-server-database-backup-trans-log_topic14179_post78481.html#78481 Author: NeutralizeR
Subject: 14179
Posted: 09 March 2005 at 8:53pm

Picture 1

Picture 2
]]> Wed, 09 Mar 2005 20:53:08 +0000 https://forums.webwiz.net/sql-server-database-backup-trans-log_topic14179_post78481.html#78481