Hi,

Having setup log shipping, the scheduled job seems to be pumping down
the logs to a failover server should something catastrophic happen to my
main server. Noting that it will copy all of my logins, permissions and
objects... has anyone got a best suggested step by step process for
bringing this server 'live' ?

P.s. is this a better solution that using a form of replication if I
want it as best failover solution without implementing clustering?

Cheers


----------------------------------------------------------------------
Scope is a registered charity number 208231.
Visit our website at http://www.scope.org.uk

This message, and any file(s) transmitted with it are confidential
and are intended only for the person(s) to whom they have been
addressed by the sender. This message may contain confidential and/or
privileged material. If you are not the intended recipient of this
message, or if you believe it was transmitted to you in error, you are
required to delete the message and any copies of it, and to notify the
sender immediately. Any unauthorised disclosure, copying, distribution,
or printing of this message or accompanying files, or unauthorised use
of any information contained therein, by anyone other than the
intended recipient(s) is prohibited and may be unlawful.

Any views expressed in this message or in any file(s) transmitted with
it are those of the author, and may not necessarily represent the
views of Scope.

MS Sql Server LazyDBA home page