AX (Loading) - Standby Database

I have SQL Server 2000 database server that I inherit from another company.
There is a AX database on this database server that was set up for Standby.
Everytime the database transaction log is created the message listed below
is inserted into the SQL Server errorlog file.
The AX database status is constantly loading is this normal?
Is it possible to set up SQL Server standby database with the SQL Server
2000 standard edition?
Errorlog Message
Bypassing recovery for database 'AX' because it is marked IN LOAD.
Thank You,Hi Joe
This is normal for standby databases. They are kept in "loading" mode
(otherwise known as "norecovery") because transaction logs are continually
being restored to them. If a standby database is brought online (by
recovering it) it will no longer be able to receive log updates from the
source db.
Regards,
Regards,
Greg Linwood
SQL Server MVP
http://blogs.sqlserver.org.au/blogs/greg_linwood
http://www.SQLBenchmarkPro.com
Join the tuning revolution..
"Joe K." <Joe K.@.discussions.microsoft.com> wrote in message
news:82161ABF-EF1E-426A-A127-AF10CF4EB32D@.microsoft.com...
> I have SQL Server 2000 database server that I inherit from another
> company.
> There is a AX database on this database server that was set up for
> Standby.
> Everytime the database transaction log is created the message listed below
> is inserted into the SQL Server errorlog file.
> The AX database status is constantly loading is this normal?
> Is it possible to set up SQL Server standby database with the SQL Server
> 2000 standard edition?
> Errorlog Message
> Bypassing recovery for database 'AX' because it is marked IN LOAD.
> Thank You,