all groups > sql server replication > may 2007 >
You're in the

sql server replication

group:

backup situation scenario


backup situation scenario luna
5/15/2007 4:29:28 PM
sql server replication:
were are planning some risk management to complement the procedures we have
in place,
we currently have an sql server (2005) and we plan to have another server
that we can take off site and bring back to site every friday for an update,
what would be the ideal solution in this case to mirror the sql server ?





Re: backup situation scenario Paul Ibison
5/15/2007 7:34:51 PM
There are a few possibilities, none of which achieve a complete mirrored
server though. Have a look in BOL at database mirroring and database log
shipping. There are 3rd party tools that can make a mirror of the server as
well.
HTH,
Paul Ibison

AddThis Social Bookmark Button