database backups

We have a Veritas application that backs up our databases at night. There are two databases that are backed up - model4IDR and master4IDR - whose lines in the log files are different. I've included some sample lines below. We the program gets to these tw
o databases the process that is running changes to spid? while the other databases are backed up by "backup". These two databases don't show up in Enterprise Manager. Why does the process start the database up first? Why would the database not be online
already? And what does the "IN LOAD" phrase mean?
Thanks,
backupDatabase backed up: Database: master, creation date(time): 2004/06/10(20:01:42)
backupDatabase restored: Database: master4IDR, creation date(time): 2004/06/10(20:01:
spid51Starting up database 'master4IDR'.
spid51Recovery is checkpointing database 'master4IDR' (15)
spid51Bypassing recovery for database 'master4IDR' because it is marked IN LOAD.
spid51Starting up database 'master4IDR'.
spid51Bypassing recovery for database 'master4IDR' because it is marked IN LOAD.
spid51Starting up database 'master4IDR'.
backupDatabase backed up: Database: master, creation date(time): 2004/06/10(20:01:42)
backupDatabase backed up: Database: model, creation date(time): 2000/08/06(01:40:52),
backupDatabase restored: Database: model4IDR, creation date(time): 2000/08/06(01:40:5
spid51Using 'xpstar.dll' version '2000.80.760' to execute extended stored procedure '
spid51Starting up database 'model4IDR'.
spid51Recovery is checkpointing database 'model4IDR' (15)
spid51Bypassing recovery for database 'model4IDR' because it is marked IN LOAD.
spid51Starting up database 'model4IDR'.
spid51Bypassing recovery for database 'model4IDR' because it is marked IN LOAD.
spid51Starting up database 'model4IDR'.
backupDatabase backed up: Database: model, creation date(time): 2000/08/06(01:40:52),
Dan D.
Perhaps the autoclose database option is set for these databases. However, considering the names of the
database, my guess is that veritas does something strange to these databases, like taking a copy of some
database and detaching the database. I'd run profiler to see what Veritas actually does. If you do find out,
I'd be happy to hear... :-)
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Dan D." <DanD@.discussions.microsoft.com> wrote in message
news:8292D621-25AB-49D5-9CF6-640749EB3568@.microsoft.com...
> We have a Veritas application that backs up our databases at night. There are two databases that are backed
up - model4IDR and master4IDR - whose lines in the log files are different. I've included some sample lines
below. We the program gets to these two databases the process that is running changes to spid? while the
other databases are backed up by "backup". These two databases don't show up in Enterprise Manager. Why does
the process start the database up first? Why would the database not be online already? And what does the "IN
LOAD" phrase mean?
> Thanks,
> backup Database backed up: Database: master, creation date(time): 2004/06/10(20:01:42)
> backup Database restored: Database: master4IDR, creation date(time): 2004/06/10(20:01:
> spid51 Starting up database 'master4IDR'.
> spid51 Recovery is checkpointing database 'master4IDR' (15)
> spid51 Bypassing recovery for database 'master4IDR' because it is marked IN LOAD.
> spid51 Starting up database 'master4IDR'.
> spid51 Bypassing recovery for database 'master4IDR' because it is marked IN LOAD.
> spid51 Starting up database 'master4IDR'.
> backup Database backed up: Database: master, creation date(time): 2004/06/10(20:01:42)
> backup Database backed up: Database: model, creation date(time): 2000/08/06(01:40:52),
> backup Database restored: Database: model4IDR, creation date(time): 2000/08/06(01:40:5
> spid51 Using 'xpstar.dll' version '2000.80.760' to execute extended stored procedure '
> spid51 Starting up database 'model4IDR'.
> spid51 Recovery is checkpointing database 'model4IDR' (15)
> spid51 Bypassing recovery for database 'model4IDR' because it is marked IN LOAD.
> spid51 Starting up database 'model4IDR'.
> spid51 Bypassing recovery for database 'model4IDR' because it is marked IN LOAD.
> spid51 Starting up database 'model4IDR'.
> backup Database backed up: Database: model, creation date(time): 2000/08/06(01:40:52),
> --
> Dan D.
|||Do you have any idea what the files are for? Since a database by that name doesn't show up in EE, I'm wondering why the file is there?
Dan D.
"Tibor Karaszi" wrote:

> Perhaps the autoclose database option is set for these databases. However, considering the names of the
> database, my guess is that veritas does something strange to these databases, like taking a copy of some
> database and detaching the database. I'd run profiler to see what Veritas actually does. If you do find out,
> I'd be happy to hear... :-)
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "Dan D." <DanD@.discussions.microsoft.com> wrote in message
> news:8292D621-25AB-49D5-9CF6-640749EB3568@.microsoft.com...
> up - model4IDR and master4IDR - whose lines in the log files are different. I've included some sample lines
> below. We the program gets to these two databases the process that is running changes to spid? while the
> other databases are backed up by "backup". These two databases don't show up in Enterprise Manager. Why does
> the process start the database up first? Why would the database not be online already? And what does the "IN
> LOAD" phrase mean?
>
>
|||Again, my guess is that it is Veritas that creates these files and does some strange detach thingy. It is not
SQL Server. Profiler will tell you.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Dan D." <DanD@.discussions.microsoft.com> wrote in message
news:022F9D75-A679-4527-B6FB-DF63828DDD5B@.microsoft.com...
> Do you have any idea what the files are for? Since a database by that name doesn't show up in EE, I'm
wondering why the file is there?[vbcol=seagreen]
> --
> Dan D.
>
> "Tibor Karaszi" wrote:
out,[vbcol=seagreen]
backed[vbcol=seagreen]
lines[vbcol=seagreen]
does[vbcol=seagreen]
"IN[vbcol=seagreen]