You need to implement option during restore of the database. If youre doing it through EM check 'able to restore additional logs' or something similar.
MC
"GB" <v7v1k3@xxxxxxxxxxx> wrote in message
news:1uMif.140296$yS6.74959@xxxxxxxxxxx > Hello:
> I'm using MS SQL Server 2000 developer edition
> and trying to implement log shipping to the secondary server.
> I copied a database MDF and LDF files from primary to secondary server
> and all data is there, but this database still in recovery mode so I can
> not
> apply log shipping to it.
> My question is:
> how to put the database on secondary server in standby or non-recovery
> mode
> to apply log shipping?
>
> Thanks,
> GB
>
>
Re: Restoring Server which utilizes Log Shipping ... The Log shipping wizard will only truncate the log after it has backed it up ... You only need the ones from the last full backup.... if you backup the log frequently to save restore time.... > I have a large database that gets a full backup every night. ... (microsoft.public.sqlserver.server)
Re: Transaction Log Shipping setup ... use the GUI on the source and remove the log shipping.... In the second case (server blown to pieces), run all the LS_Restore jobs to ...restore database MyDestinationDB with recovery ... how do you get the database to be fully functioning? ... (microsoft.public.sqlserver.replication)
Re: error when using log shipping ... Looking for a SQL Server replication book?... You can bring the secondary database online by restoring a tail / ... transaction log from the primary using "Recovery" from the Restore... the secondary server is supposed to be inaccessible. ... (microsoft.public.sqlserver.replication)
Database goes into Supect or Loading state after Restore ... I am do log shipping from one server to another. ... It just stays there until I do a manual restore.... only difference between this database and the others is the size. ...RESTORE DATABASE W3Data... (microsoft.public.sqlserver.replication)
Re: Transaction Log Shipping setup ... The restore only takes a few seconds. ... how do you get the database to be fully functioning? ... Will removing the instance from the log shipping setup on the primary ... you have a Standby option in the restore tab of ... (microsoft.public.sqlserver.replication)
