January 31, 2012 at 7:29 am
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
January 31, 2012 at 8:26 am
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..
Blog -- LearnSQLWithBru
Join on Facebook Page Facebook.comLearnSQLWithBru
Twitter -- BruMedishetty
January 31, 2012 at 9:20 am
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
January 31, 2012 at 9:44 am
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..
Blog -- LearnSQLWithBru
Join on Facebook Page Facebook.comLearnSQLWithBru
Twitter -- BruMedishetty
January 31, 2012 at 9:59 am
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
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply