Re: Is this normal

Tech-Archive recommends: Fix windows errors by optimizing your registry

Yes, it is constantly restoring the shipped logs.
"Mike" <Mike@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message news:EB3D36B5-E61F-4667-944D-C2E376736026@xxxxxxxxxxxxxxxx
Hi

I am a complete noob when it comes to SQL, but I am trying to get log
shipping working accross 2 servers.

I have restored the database to the primary server and this has worked fine.

I then go into the properties of the database and select log shipping.

I complete the sections as required, including the part about recover the
database to the secondary server.

The secondary server starts the restore and the log files are placed on the
share I created for the primary to put and the secondary to get from.

So far so good.

My question is, the secondary server's status on the recovery is constantly
saying that its restoring, even for a couple of hours when I am using a 1gb
test DB.

The secondary servers logs report that it is picking up the logs and
everything is working, should the secondary server be constantly in a state
of restore?

Thanks in advance.

Mike

.

Relevant Pages

  • Re: log shipping
    ... > It looks like this SP may set the secondary server ... > up as a primary server, as well as restoring the logs and bringing its ... My impression of a "warm standby" is that it is ready to fill in but it is ...
    (microsoft.public.sqlserver.programming)
  • Re: NTBackup / No Entires Found
    ... Restoring part of an Exchange backup (just a ... database or some logs) wouldn't work and thus I guess its just trying to ... > But when going to "Restore and Manage Media", select the tape media, under ... > log files, Mailbox Store and Public folder Store, they all show "No ...
    (microsoft.public.exchange.admin)
  • Re: How to replay current log files after an restore????
    ... When database is restored and logs are replayed, ... My intention is to restoring the database to the current ... state using the last night backup and with the current transaction ...
    (microsoft.public.exchange.admin)
  • SQL Server 2000 Backup + Restore question
    ... and the answer is unclear. ... Back up logs every five minutes. ... but restoring the database all the way through can ... but assuming I never want to do that, can I discard the logs ...
    (comp.databases.ms-sqlserver)
  • Placing Log on another drive
    ... After a new disk has been installed what is the ... easiest way way to move the logs to the new ... I'm thinking of dumping and restoring the database using ...
    (microsoft.public.sqlserver.server)