Best way to take backUp

Which is the best way to take BackUp of the DB from MSSQL 2000 to a
secondary server with out loosing any single Insert/update?Hi
Do you want the secondary server read only ?
1)Log shipping
2) Repliaction
"imtiaz" <Imtiaz@.microsoft.com> wrote in message
news:uioGWaxfGHA.3860@.TK2MSFTNGP02.phx.gbl...
> Which is the best way to take BackUp of the DB from MSSQL 2000 to a
> secondary server with out loosing any single Insert/update?
>|||Yes I want secondary server to be readonly/ or to a backup device is also
will work.
Can you please explain the following in detail(steps)
1.log shipping
2.replication
Thanks in advance
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:OFfRO3xfGHA.1276@.TK2MSFTNGP03.phx.gbl...
> Hi
> Do you want the secondary server read only ?
> 1)Log shipping
> 2) Repliaction
> "imtiaz" <Imtiaz@.microsoft.com> wrote in message
> news:uioGWaxfGHA.3860@.TK2MSFTNGP02.phx.gbl...
>|||Check this out
http://www.sql-server-performance.c...og_shipping.asp
I guess it would give you an good idea about Log Shipping in SQL Server.
Best Regards
Vadivel
http://vadivel.blogspot.com
"imtiaz" wrote:

> Yes I want secondary server to be readonly/ or to a backup device is also
> will work.
> Can you please explain the following in detail(steps)
> 1.log shipping
> 2.replication
> Thanks in advance
> "Uri Dimant" <urid@.iscar.co.il> wrote in message
> news:OFfRO3xfGHA.1276@.TK2MSFTNGP03.phx.gbl...
>
>|||http://www.sql-server-performance.c...og_shipping.asp
About replications it is very big topic , you are going to spend a lot of
time to learn it
http://www.mssqlcity.com/Articles/Replic/Replic.htm --Setting All
Replica (Step by step)
"imtiaz" <Imtiaz@.microsoft.com> wrote in message
news:OlYL4AyfGHA.1792@.TK2MSFTNGP03.phx.gbl...
> Yes I want secondary server to be readonly/ or to a backup device is also
> will work.
> Can you please explain the following in detail(steps)
> 1.log shipping
> 2.replication
> Thanks in advance
> "Uri Dimant" <urid@.iscar.co.il> wrote in message
> news:OFfRO3xfGHA.1276@.TK2MSFTNGP03.phx.gbl...
>