Post reply

Database and Log Backup Failing everyday, Backups are maintained in Tape through TDP Tool

  • February 1, 2012 at 2:39 am

    #254601

    I am getting regular backup failed tickets on a Database. When checked in server , database name dosnt exist, it comes with an extension of existing Database.

    The error i am getting on a database with database name and extension as DBName__20120131_140010_8237335.

    Here is the log of TDP

    “01/27/2012 20:05:36 Database Database_20120128_030053_1646338' does not exist. Make sure that the name is entered correctly.01/27/2012 20:05:36 BACKUP DATABASE is terminating abnormally.01/27/2012 20:05:36 Changed database context to 'master'. (HRESULT:0x80131501)”

    We have a Daily full Backup and every 15 mins Log backup. where the backups are available for the mentioned Database. But what is happening is we are getting an error mesg in SQL Server Log, saying Backup failed for the DB__20120131_140010_8237335, where Database with this name dosent exist. I just wanted to know , why we are getting these error mesgs after the backups are successful. And also why we are getting regular mesgs saying Starting up Database__20120131_140010_8237335.

    If any confusion please let me know

    Thanks in Advance.

    Regards

    Ram

  • February 1, 2012 at 3:01 am

    #1441101

    Ram

    Unless there's someone here with a lot of experience with TDP, I think you'd be best off posting this question on a TSM/TDP forum, or getting support from IBM or whoever the vendor is.

    As for your second question, does this return any results?

    SELECT name FROM master.sys.databases

    WHERE is_auto_close_on = 1

    John

  • February 1, 2012 at 5:02 am

    #1441129

    Hi John thanks for your suggestion on TDP/TSM.

    I ran the query which you gave me , Query ran successfull with zero rows affected.

    Thanks

    Ram

  • February 1, 2012 at 5:04 am

    #1441130

    Ram

    OK, I don't know why you're getting those messages, then. Sorry.

    John

  • February 1, 2012 at 2:25 pm

    #1441439

    Just from looking at your errors and not knowing anything about TDP, I can only guess that something has changed ans is adding a timestamp to the database for which it is looking for. Maybe a script change or a bug? Same with the restore. It is as if the tape is trying to restore a database with a backup? Strange indeed...

    Jared
    CE - Microsoft

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply