Database Replication

Hi everybody

Can I replicate a database onto a seperate instance of SQL? I need to
replicate a database to a stand-alone machine with no connectivety to
anything. Does anyone know where I can find info on this?

Thanks for any help.


--
Message posted via webservertalk.com
http://www.webservertalk.com/Uwe/Fo...eneral/200509/1

Perhaps in Books Online, under "Replication"? :-)  And I guess you
don't really mean "no connectivity to anything", otherwise it would be
somewhat difficult to implement. Depending on what your goal is
(availability, disaster recovery, offline reporting etc.) you could
also look at log shipping, clustering, and of course backup/restore.

Replication is quite a specialized area, so if you have specific
questions about it, you'll probably get a better response in
microsoft.public.sqlserver.replication.

Simon

Thanks Simon. I did check the Books  Online ;-). All I need is our online
database on another stand-alone computer
that is not connected to any network (due to stupid security). I need this
for a whole bunch of testing on one of our apps. I think that the
backup/restore option would be better?


--
Message posted via webservertalk.com
http://www.webservertalk.com/Uwe/Fo...eneral/200509/1

If you have no network connection, you'll need to copy the database to
a physical medium (DVD, tape, USB drive) anyway, so backup/restore
would be the only real option (you could detach/attach, but that would
mean taking the source offline).

Also see this article:

http://support.microsoft.com/defaul...kb;en-us;314546

Simon