Backing up a restoring or standby database

Hi,
I would like to backup a secondary log shippping database (in restoring or
standby mode). I need to use the backup as an up to date test database on the
same server but don't have the bandwidth to copy the primary backups over.
I've tried the backup command which results in an error saying that the
restore sequence must be completed first.
I also tried detaching the database with a view to copying the files but
when attempting to attach it again sql server produced another restore
sequence error.
Anyone know if it is possible to do a backup of a log shipping secondary, by
foul means or fair?
Cheers,
Kev.
You'd have to use recovery to be able to do the backup but this'd invalidate
the log-shipping chain. for a test database you might roll your own 'database
shipping' solution which is something a few people on this newsgroup seem to
be using...
HTH,
Paul Ibison
|||Okay, thanks.
Kev.
"Paul Ibison" wrote:

> You'd have to use recovery to be able to do the backup but this'd invalidate
> the log-shipping chain. for a test database you might roll your own 'database
> shipping' solution which is something a few people on this newsgroup seem to
> be using...
> HTH,
> Paul Ibison
>

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,

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,