Re: How to Replicate an SQL Server 2000 Database

Hi Hilary,

I am assuming QA means Query Analyser?

If i do this in Query Analyser should i have the DB closed? As well as the
Apache Tomcat Windows which accept input from Clients and relay from DB?

Are you 100% sure this will not effect any of my coding or clients?
And do i just restart SQL or the Server?

Now regarding Replication, i am brand new to this... is there a way of just
replicating the database (mdl) files to another Hard Drive somewhere? Or do i
need to set up another machine with SQL Server and start replicating to this?

Thanks for your quick response.

--
Regards
Glen Pankhurst
Research & Development Manager


"Hilary Cotter" wrote:

Go to a command prompt and type hostname. This is your computer name

Then in QA do the following

EXEC sp_dropserver '(local)
GO
EXEC sp_addserver 'Name Returned from hostname', 'local'
GO

And then stop and start SQL Server. Try again.

Your users will be able to connect as before only they will be disconnected
as you restart.

Note further that you should be using transactional replication (assuming
all of your tables have primary keys).

--
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.

This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.

Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html

Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com



"Bondwireless" <Bondwireless@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:FBE1D332-25DC-405D-9F8A-7B651B11F96C@xxxxxxxxxxxxxxxx
Hi, i am new to this so really need some helpfull and easy to follow
information so that i can successfully replicate my SQL Server Database.

Here is my dilema. I have a working SQL Server 2000 Database which has an
IP
address and alias so can be connected to by the outside world. However on
the
machine it is running on, it is called (local).

Now when i went to use the replication wizard it won't let me with my
database being called (local) and i can't seem to rename it without
re-registering it. Would this entail creating a new Database and copying
all
the tables across? How would this effect my users connecting to my
Database
(since there will be an introduction of a name for my database as apposed
to
the one called (local))

Once this is all done, what are my options? Can i simply replicate my
entire
database to another hard drive? Can i replicate it to another server
running
SQL Server 2000 with no database configured? Or would i have to have a
copy
of the DB already on the other server?

Once replication is done is there a way of keeping the databases
synchronised so that in the case of a failure on the first Server, i could
switch over to the backup Server? Would synchronisation be automatic or
would
i have to do it manually?

Your answers would be greatly appreciated.

--
Regards
Glen Pankhurst
Research & Development Manager



.

Relevant Pages

  • Re: Replication Suggestions
    ... Looking for a SQL Server replication book? ... >I have an application with a sql backend. ... > database on the webbox and an internal database for inter-company use. ...
    (microsoft.public.sqlserver.replication)
  • Replicate to MS Access via the Internet
    ... Can I use SQL Server’s inbuilt replication to replicate between a SQL Server ... database and a number of MS Access 97, 2000 and 2002 databases over the ... The clients modify their local ...
    (microsoft.public.sqlserver.replication)
  • Replicate to MS Access via the Internet
    ... Can I use SQL Server’s inbuilt replication to replicate between a SQL Server ... database and a number of MS Access 97, 2000 and 2002 databases over the ... The clients modify their local ...
    (microsoft.public.access.replication)
  • Re: User ID and Password in the Query
    ... Pro SQL Server 2000 Database Design - ... > How can I pass the user id and password in a simple SQL statement. ... I am logged into a database. ... Without logging into query analyser with his credentials(I had ...
    (microsoft.public.sqlserver.programming)
  • Re: How convert from Desktop to PDA
    ... Replication is used when you want to synchronize the SQL Server ... You may also do that with RDA, ... > How can I convert an Sql Server database on desktop into a Sql server CE ...
    (microsoft.public.sqlserver.ce)