Put database in warm standby after changing it from read only?

We have a server at a disaster recovery site that was in warm standby. In
order for the server to be fully functional, we had to bring the databases
out of warm standby to install some client software that read the databases
of the standby server. While trying to put the databases back into warm
standby restoring the next log in sequence from the production server, I get
an error saying "Exclusive access could not be obtained because the database
is in use". However, the database is in single-user mode. When trying a
restore log command in SQL, I get an error "preceding restore operation did
not specify WITH NORECOVERY or WITH STANDBY. RESTORE LOG is terminating
abnormally.
Is there any way to get the database(s) back into warm standy mode without
having to set it up again from scratch?
Thanks,
RS
Nope. Once it is set to "normal" mode you have to restore a full backup
WITH STANDBY.
Keith
"RS" <rspen@.yahoo.com> wrote in message
news:%23y9Z2Y7eEHA.2764@.TK2MSFTNGP11.phx.gbl...
> We have a server at a disaster recovery site that was in warm standby. In
> order for the server to be fully functional, we had to bring the databases
> out of warm standby to install some client software that read the
databases
> of the standby server. While trying to put the databases back into warm
> standby restoring the next log in sequence from the production server, I
get
> an error saying "Exclusive access could not be obtained because the
database
> is in use". However, the database is in single-user mode. When trying a
> restore log command in SQL, I get an error "preceding restore operation
did
> not specify WITH NORECOVERY or WITH STANDBY. RESTORE LOG is terminating
> abnormally.
> Is there any way to get the database(s) back into warm standy mode without
> having to set it up again from scratch?
> Thanks,
> RS
>
sql