May 30, 2008 at 12:38 am
Hi All,
How am I to avoid transactional log full in sql server 2000.
Please help me out.
Thanks in advance.
June 3, 2008 at 2:26 am
backup the tran log
June 3, 2008 at 2:34 am
Inorder to avoid it you need to perform the following,
1. If your database is in Full/Bulk logged recovery model you need to take regular transaction log backups which will truncate the log file.
Backup log dbname to disk='Path\filename.trn'
2. Ensure you set the log file growth as unlimited instead of restricted.
3. Otherwise opt for Simple recovery model where the log file will be truncated automatically when checkpoint occurs.
Refer these links for more info where similar topic was discussed,
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=2728787&SiteID=1
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=2522242&SiteID=1
[font="Verdana"]- Deepak[/font]
June 3, 2008 at 2:15 pm
Agree with Deepak, and Take a Tlog will free your space and than Shrink the Log file.
You can use DBCC SHRINKFILE(Logfilename)
MCP, MCTS (GDBA/EDA)
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply