SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


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


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

Author
Message
rgvala
rgvala
Grasshopper
Grasshopper (12 reputation)Grasshopper (12 reputation)Grasshopper (12 reputation)Grasshopper (12 reputation)Grasshopper (12 reputation)Grasshopper (12 reputation)Grasshopper (12 reputation)Grasshopper (12 reputation)

Group: General Forum Members
Points: 12 Visits: 92
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
Bru Medishetty
Bru Medishetty
SSCertifiable
SSCertifiable (5.9K reputation)SSCertifiable (5.9K reputation)SSCertifiable (5.9K reputation)SSCertifiable (5.9K reputation)SSCertifiable (5.9K reputation)SSCertifiable (5.9K reputation)SSCertifiable (5.9K reputation)SSCertifiable (5.9K reputation)

Group: General Forum Members
Points: 5926 Visits: 1950
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
rgvala
rgvala
Grasshopper
Grasshopper (12 reputation)Grasshopper (12 reputation)Grasshopper (12 reputation)Grasshopper (12 reputation)Grasshopper (12 reputation)Grasshopper (12 reputation)Grasshopper (12 reputation)Grasshopper (12 reputation)

Group: General Forum Members
Points: 12 Visits: 92
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
Bru Medishetty
Bru Medishetty
SSCertifiable
SSCertifiable (5.9K reputation)SSCertifiable (5.9K reputation)SSCertifiable (5.9K reputation)SSCertifiable (5.9K reputation)SSCertifiable (5.9K reputation)SSCertifiable (5.9K reputation)SSCertifiable (5.9K reputation)SSCertifiable (5.9K reputation)

Group: General Forum Members
Points: 5926 Visits: 1950
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
rgvala
rgvala
Grasshopper
Grasshopper (12 reputation)Grasshopper (12 reputation)Grasshopper (12 reputation)Grasshopper (12 reputation)Grasshopper (12 reputation)Grasshopper (12 reputation)Grasshopper (12 reputation)Grasshopper (12 reputation)

Group: General Forum Members
Points: 12 Visits: 92
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
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search