What is master4IDR? and 'model4IDR'.

Question

Post reply

What is master4IDR? and 'model4IDR'.

Viewing 8 posts - 1 through 9 (of 9 total)

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

Shree_h Mr or Mrs. 500 Points: 568 More actions · Answer 1

Hi..

Do you have any database with name maste4IDR?

It's a info message displayed after DBCC command run on your database.

If you get this message regularly check if there is any job created for it in maintenance plan or under jobs.

Shree

Gail Shaw SSC Guru Points: 1004514 More actions · Answer 2

shripati (7/27/2009)
It's a info message displayed after DBCC command run on your database.
If you get this message regularly check if there is any job created for it in maintenance plan or under jobs.

Nope, actually it's displaying the date and time of the last known good run of CheckDB. When CheckDB runs and doesn't find any errors, it updates a datetime in the database header page. Each time the database is started (at server startup or when it's brought online), SQL will read that and write into the error log a message saying when checkDB last ran without errors.

This looks like a restore of a database called maste4IDR. That's not a system or standard database, either it's something you or your predecessors set up, or it's something that an app you're running has set up.

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Krasavita SSC-Insane Points: 23138 More actions · Answer 3

No, I don't have maste4IDR set up, I don't see it anywhere and I don't know where it is comming from

JamieX Hall of Fame Points: 3763 More actions · Answer 4

Did you check what GilaMonster said? Is there an application creating these?

Since your backup is using a virtual device and the databases have IDR in them, I'd guess your backup software is going to tape and creating the databases in some sort of IDR (usually,- intelligent disaster recovery) test afterwards.

Edit-

Decided to do a quick google search --- found like 1000 pages mentioning these databases and veritas(symantec) backup exec..

bethrich SSC Veteran Points: 288 More actions · Answer 5

It is indeed related to Backup Exec. I have seen these on some of our older servers where Backup Exec has been removed.

Beth Richards
Sybase, Oracle and MSSQL DBA

jacky_chen SSC Rookie Points: 39 More actions · Answer 6

bethrich (7/29/2009)
It is indeed related to Backup Exec. I have seen these on some of our older servers where Backup Exec has been removed.

Yes.

Gail Shaw SSC Guru Points: 1004514 More actions · Answer 7

Please note: Year-old thread.

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

mike.schmid SSC Journeyman Points: 97 More actions · Answer 8

Backup Exec indeed. I have a a few SQL servers with Backup Exec on them. The older Backup Exec versions with Intelligent Disaster Recovery use DB's with the IDR suffix.