MS SQL Server - master table

Author

master table

Martin

2006-03-10, 11:23 am

Recently, I noticed that our SQL Server has two system tables that I don't
think I have seen them there before. They are master$4IDR and model$4IDR.
They seem to run together with the master and model table with the same
physical file size. I checked the log files and there shows something I am
hoping it is related to this issue. It said something during our backup
cycle, "Bypassing recovery for database 'master4IDR' because it is marked IN
LOAD", and "Bypassing recovery for database 'model4IDR' because it is marked
IN LOAD".
I wonder if this is a normal behavior and how it happened. Should it be my
concern as a DBA?
Thanks!
Martin

Tibor Karaszi

2006-03-10, 11:23 am

These are not created by SQL Server. I think they are created by Backup Exec (or some other #:rd
party program). Google for the names and you should find some more information.

--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www. solidqualitylearning
.com/
Blog: http:// solidqualitylearning
.com/blogs/tibor/

"Martin" <Martin@discussions.microsoft.com> wrote in message
news:9676863A-A154-4B53-A361- D79917C3921B@microso
ft.com...
> Recently, I noticed that our SQL Server has two system tables that I don't
> think I have seen them there before. They are master$4IDR and model$4IDR.
> They seem to run together with the master and model table with the same
> physical file size. I checked the log files and there shows something I am
> hoping it is related to this issue. It said something during our backup
> cycle, "Bypassing recovery for database 'master4IDR' because it is marked IN
> LOAD", and "Bypassing recovery for database 'model4IDR' because it is marked
> IN LOAD".
> I wonder if this is a normal behavior and how it happened. Should it be my
> concern as a DBA?
> Thanks!
> Martin
>

Sponsored Links