By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,521 Members | 1,252 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,521 IT Pros & Developers. It's quick & easy.

log shipping

P: n/a
GB
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
Nov 28 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
MC
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" <v7****@hotmail.com> wrote in message
news:1uMif.140296$yS6.74959@clgrps12...
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

Nov 29 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.