Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Database backup and Log backup Failing regularly, backups maintained in TDP Expand / Collapse
Author
Message
Posted Tuesday, January 31, 2012 7:29 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, December 19, 2013 8:17 AM
Points: 8, Visits: 87
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
Posted Tuesday, January 31, 2012 8:26 AM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Monday, February 11, 2013 8:27 AM
Points: 1,646, 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
Posted Tuesday, January 31, 2012 9:20 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, December 19, 2013 8:17 AM
Points: 8, Visits: 87
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
Posted Tuesday, January 31, 2012 9:44 AM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Monday, February 11, 2013 8:27 AM
Points: 1,646, 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
Posted Tuesday, January 31, 2012 9:59 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, December 19, 2013 8:17 AM
Points: 8, Visits: 87
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 »

Add to briefcase

Permissions Expand / Collapse