all groups > sql server replication > october 2006 >
You're in the

sql server replication

group:

Server to server backup


Server to server backup angelin
10/31/2006 12:00:00 AM
sql server replication:
I need to take backups of all DBs in the server into another serve, which
should be done automatically once a particular period of time(say 30 mins or
2 hrs or 5 hrs etc..).
Please help me to do so with step by step explanation. iI am new to SQL
Server.

--
Regards
Angelin Enita.A

Re: Server to server backup Paul Ibison
10/31/2006 12:00:00 AM
The easiest out of the box solution is log shipping which is well-documented
in books on line (BOL). It's not exactly what you requested, but achieves
the same ends by shipping just the differences since the last
synchronization and this almost always amounts in smaller files being
shipped. The only restriction that distinguishes it from your request is
that the database will be read-only.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com .

AddThis Social Bookmark Button