Backup server

I currently have a main database server and want to implement a backup
server that replicates the data in my main server.
What is the best method of implementing this? I really don't know where to
start so even a pointer at some reading material would be helpful. Any
advice will be appreciated.
Hi
Look up Log Shipping and Replication in BOL (or the Microsoft web site).
Those are your 2 built-in options.
Regards
Mike
"Michael" wrote:

> I currently have a main database server and want to implement a backup
> server that replicates the data in my main server.
> What is the best method of implementing this? I really don't know where to
> start so even a pointer at some reading material would be helpful. Any
> advice will be appreciated.
>
>
|||That depends on if you want to copy all of the data or a subset of the data.
If you want all the data and system objects and your destination database
can go offline while the transaction logs are applied, and is read only,
then log shipping is for you.
If you want only a subset of the data and don't care about the system
objects (like permissions, etc), need continualy accessability of the
destination database, and want to be able to update the destination database
use replication. Note that if you are not careful the updates you make on
the destination database can disrupt the replication process, but you can
partition your data so it doesn't.
"Michael" <michael@.hello.com> wrote in message
news:356vljF4i904nU1@.individual.net...
>I currently have a main database server and want to implement a backup
>server that replicates the data in my main server.
> What is the best method of implementing this? I really don't know where to
> start so even a pointer at some reading material would be helpful. Any
> advice will be appreciated.
>
sql