Database backup and Log backup Failing regularly, backups maintained in TDP

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 7,2000 » Backups » Database backup and Log backup Failing...

Database backup and Log backup Failing regularly, backups maintained in TDP

Rate Topic

Display Mode

Topic Options

Author

Message

rgvala

Posted Tuesday, January 31, 2012 7:29 AM

Forum Newbie

Group: General Forum Members
Last Login: Thursday, February 07, 2013 6:21 AM
Points: 5, Visits: 83

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)”

Can anyone give me the solution for this.

Thanks in Advance.

Regards
Ram

Post #1244371

Bru Medishetty

Posted Tuesday, January 31, 2012 8:26 AM

SSCommitted

Group: General Forum Members
Last Login: Monday, February 11, 2013 8:27 AM
Points: 1,735, Visits: 1,947

How are the backups configured?

If you doing it from a custom script, check if the database names are hard-coded and remove that db name from that list of db's to be backed up..

More info on how your db's are backed up can help in troubleshooting the problem..

Bru Medishetty

Blog -- LearnSQLWithBru

Join on Facebook Page Facebook.com\LearnSQLWithBru

Twitter -- BruMedishetty

Post #1244440

rgvala

Posted Tuesday, January 31, 2012 9:20 AM

Forum Newbie

Group: General Forum Members
Last Login: Thursday, February 07, 2013 6:21 AM
Points: 5, Visits: 83

Hi thanks for the reply

I dont know how they are configured, this is on my interest i wanna know our 3rd level team are looking into it , i am a second level DBA. But as per my observation , for example we have a Test DB for which the backups are being done through TDP. Now the regular full backup daily once and the log backup every 15mins is being backed up without any errors.
But when the Log backup is successful the next minute we are getting log backup failed for Test_20120128_030053_1646338. It occurs twice giving the error
"BACKUP failed to complete the command BACKUP LOG Test_20120131_150008_1732200. Check the backup application log for detailed messages."

In the SQL Log file we are getting frequent messeges showing"Starting up database 'Test_20120131_150015_5640815'."

Where we dont have a database with that name.

Please let me know if you need anything else

Thanks
Ram

Post #1244505

Bru Medishetty

Posted Tuesday, January 31, 2012 9:44 AM

SSCommitted

Group: General Forum Members
Last Login: Monday, February 11, 2013 8:27 AM
Points: 1,735, Visits: 1,947

What is TDP?

Not knowing how the backups are configured is dangerous, as you (the DBA responsible for that SQL Server) has to know how are the backups configured in order to change / add a new database to the backup job. Let's assume if there is a new database that needs to be created on that instance and it has to be backed-up regularly how are you guys going to ensure that?

Regarding the error message starting up database xxxx, which does not exist on your SQL Server, I do not have a clue..

Sorry couldn't be of much help..

Bru Medishetty

Blog -- LearnSQLWithBru

Join on Facebook Page Facebook.com\LearnSQLWithBru

Twitter -- BruMedishetty

Post #1244531

rgvala

Posted Tuesday, January 31, 2012 9:59 AM

Forum Newbie

Group: General Forum Members
Last Login: Thursday, February 07, 2013 6:21 AM
Points: 5, Visits: 83

TDP - Tivoli Data Protection is a client tool (Tape Drive) where all of our SQL Databases are Backedup.
I know how to configure backups in SQL Server(TSM), but i am new to this TDP Tool.
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 DBXXXXX, 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 Databasexxxx.

Thanks

Post #1244552

« Prev Topic | Next Topic »

Permissions