Results 1 to 4 of 4

Thread: Sql server 2005 log backup failed

  1. #1
    Join Date
    Jan 2009
    Posts
    97

    Sql server 2005 log backup failed

    In our organisation, there is a sql server which is backed up every night. and the backup of all the transaction logs is made. Since some days i'm getting this error "BACKUP LOG cannot be performed because there is no current database backup" I don't know what is wrong. I'm running the server in full recovery mode. Help!

  2. #2
    Join Date
    Apr 2008
    Posts
    2,005

    Re: Sql server 2005 log backup failed

    Quote Originally Posted by Saaz View Post
    BACKUP LOG cannot be performed because there is no current database backup
    The Server is alright and nothing is wrong. When running in full recovery mode, there should be a backup made for the database before making the backup of the log. Try backing up the the database and then backup the logs and see if that works!?

  3. #3
    Join Date
    May 2008
    Posts
    2,389

    Re: Sql server 2005 log backup failed

    As you said you are in full recovery mode. Switch to simple mode before doing anything, and now again switch back to the full recovery mode. Backup the database and now perform the log backup what do you see? This might help you solve the problem, if not atleast a step closer to solving it..!

  4. #4
    Join Date
    Jan 2009
    Posts
    97

    Re: Sql server 2005 log backup failed

    Guys, many thanks for your suggestions. I still don't know what has happened to the system, still in full recovery mode. As soon as i backed up the database, the log backup were just fine then. This was a weird but a great learning experience. Thanks again for helping me out..

Similar Threads

  1. Windows 7 Backup : Server execution failed(0x80080005)
    By wirelessprom in forum Networking & Security
    Replies: 8
    Last Post: 23-11-2010, 09:51 AM
  2. Replies: 2
    Last Post: 28-09-2010, 04:06 PM
  3. Replies: 1
    Last Post: 04-04-2009, 01:44 AM
  4. Upgrade fails: SQL Server Express 2005 to SQL Server 2005
    By Steve BB in forum Small Business Server
    Replies: 3
    Last Post: 11-06-2008, 07:37 PM
  5. Replies: 5
    Last Post: 20-05-2008, 05:05 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,717,394,988.29835 seconds with 16 queries