Results 1 to 4 of 4

Thread: How to take backup of tempdb transaction Log Files?

  1. #1
    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..

  2. #2
    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.

  3. #3
    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.

  4. #4
    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.

Similar Threads

  1. Transaction backup Logs Not working properly With SQL
    By Ossi in forum Software Development
    Replies: 4
    Last Post: 29-12-2010, 07:40 AM
  2. Backup files from one drive to another
    By Amaya in forum Operating Systems
    Replies: 4
    Last Post: 09-09-2010, 03:23 PM
  3. Replies: 3
    Last Post: 03-07-2010, 12:57 PM
  4. Replies: 4
    Last Post: 27-03-2010, 05:59 AM
  5. Can't backup frx files
    By Avinash Kaur in forum Windows Software
    Replies: 3
    Last Post: 13-03-2009, 03:38 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Page generated in 1,714,168,147.84095 seconds with 16 queries