Database Replication

#1

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 SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums...neral/200509/1

#2

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

#3

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 SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums...neral/200509/1

#4

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/default...b;en-us;314546

Simon

#5

On Sep 4, 10:50 pm, "Andi" <NOmgem35S... (AT) dslDOT (DOT) pipex.net> wrote:

Quote:

Hi,

Wondering if anyone can help. We have a knowledge base system which uses an
MSSQL server to store information. The tool is web-based, and we have need
to run reports on the information in the database, such as number and age of
articles, for example.

As the tool is used quite heavily, we can't afford the drop in performance
that reporting on the live database would cause, so we have setup another
database server which is to hold a copy of the database.

We have a job set up in Enterprise Administrator which takes a backup of the
database from the live server every night and copies it over to the
reporting server. A job on the reporting server then restores the copy from
the live server over the top.

However, the job on the reporting server consistently fails when it is run.
It appears as though the database file on the reporting server is becoming
unusable, however the copy remaining on the live server is fine.

We are able to restore the database by manually copying over the file,
however this takes up valuable DBA time that could be better used
elsewhere - has anyone else ever experienced anything like this, and if so
how did you get round it?

The database backup file is around 3.5GB in size.

Cheers,

Andi

Which version of sql server you are using ?

For the above requirement log shipping (if destination is for read
only purpose) or transactional replciation can be usefull

you can refere books online for setp info

Let me know if anything needed on this

Thanks
Vijayasekar

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Database Replication

comp.databases.ms-sqlserver comp.databases.ms-sqlserver

Database Replication - 09-28-2005 , 03:47 AM

Re: Database Replication - 09-28-2005 , 04:37 AM

Re: Database Replication - 09-28-2005 , 06:24 AM

Re: Database Replication - 09-28-2005 , 06:54 AM

Re: Database replication - 09-05-2007 , 09:47 AM