October 2, 2003 at 2:48 pm
my prob with my database is log file is growing alarmingly how to control log file.
my data files is comparatively small to log
file
balaji ramanar
balaji ramanar
October 2, 2003 at 2:59 pm
You can set database in 'simple recovery' mode to let system to truncate the log file if your database doesn't need to be recovered to the point of failure or to a specific point in time.
IF you do need above recovery, backup the transaction log regularly. You can use maintenance wizard to create job and schedule it to run.
Now you may already have large transaction log file, you can set the dataabse in 'simple recovery' mode, backup log with truncate only, shrink the log file size and reset the dataabse to 'full recovery' mode that is recommened for your production database, perform the full backup and run transaction log backup by scheduling it.
October 2, 2003 at 3:41 pm
If disk space is an issue, and you can afford a little time, you might also run a differential backup once or twice a day and delete all log files (or move them to another server/tape) between the full backup and the differential.
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply