Go Back   TechArena Community > Software > Software Development
Become a Member!
Forgot your username/password?
Tags Active Topics RSS Search Mark Forums Read

Reply
 
Thread Tools Search this Thread
  #1  
Old 04-08-2009
Member
 
Join Date: Oct 2008
Posts: 100
How to take backup of tempdb transaction Log Files?

Can you please explain how to make a backup for the log file. This is because i have given my site for web hosting and i have started taking the backup of all the log files, there i found Tempdb Transaction Log being full and getting an error 9002 severity 17 state 2? When i generate the log file it forward me the 4 GIG size. which i think i have not taken the backup properly, Please suggest..
Reply With Quote
  #2  
Old 04-08-2009
Member
 
Join Date: Feb 2008
Posts: 137
Re: How to take backup of tempdb transaction Log Files?

The SQL Server transaction log can become full, which prevents further UPDATE, DELETE, or INSERT activity in the database, including CHECKPOINT. You can check out the actual size of the tempdb using sp_helpdb 'tempdb'. If it is not negative you don't have to worry and tempdb goes on increasing when required.
Reply With Quote
  #3  
Old 04-08-2009
Member
 
Join Date: Feb 2008
Posts: 121
Re: How to take backup of tempdb transaction Log Files?

Have you check whether you have enough disk space on logfile partition? Have you ever truncate (with backup log) your log file...? Backing up the log frees space by removing committed transactions from the log. This is usually seen as error 1105: and this can happen on any database, including master or tempdb. and the error 1105 suggest the following: Can't allocate space for object syslogs in database dbname because the log segment is full. If you ran out of space in syslogs, dump the transaction log. Otherwise use ALTER DATABASE or sp_extendsegment to increase the size of the segment.
Reply With Quote
  #4  
Old 04-08-2009
Member
 
Join Date: Jan 2009
Posts: 150
Re: How to take backup of tempdb transaction Log Files?

Your SQL Server might be experienced a power failure, operating system crash, automatically recovering the database to a consistent state. And as per me Recovery model simple shouldn't grow your logfile. Maybe some application never commits or a lot of image/text manipulations are going on using the with log option but no commits.
Reply With Quote
Reply

  TechArena Community > Software > Software Development
Tags: , ,



Thread Tools Search this Thread
Search this Thread:

Advanced Search


Similar Threads for: "How to take backup of tempdb transaction Log Files?"
Thread Thread Starter Forum Replies Last Post
Transaction backup Logs Not working properly With SQL Ossi Software Development 4 29-12-2010 07:40 AM
Backup files from one drive to another Amaya Operating Systems 4 09-09-2010 03:23 PM
best backup software for Vista Home Ultimate that will allow me to select files and folders to backup and restore Lynette Windows Vista Performance 3 03-07-2010 12:57 PM
Unable to complete backup. An error occured while copying files to the backup volume. austin26 Windows Software 4 27-03-2010 05:59 AM
Can't backup frx files Avinash Kaur Windows Software 3 13-03-2009 03:38 PM


All times are GMT +5.5. The time now is 02:16 PM.