BackOffice Products
1844859 Members
2248 Online
110233 Solutions
New Discussion

SQL DDBB REplication

 
SOLVED
Go to solution
Edgar Zapata
Esteemed Contributor

SQL DDBB REplication

We have a Data Base in SQL Server 2000.
We want to replicate the whole DataBase as part of our recovery system.
So if the DB or server fails we can change IPs and our API will work with DATA in the replication server.

Any clue?

regards.
2 REPLIES 2
Dilip Kumar_4
Advisor
Solution

Re: SQL DDBB REplication

There is whole chapter dedicated to "replication" in the SQL Server "books on-line". It should have got installed on the SQL-Server machine.
This should do the trick.
Edgar Zapata
Esteemed Contributor

Re: SQL DDBB REplication

Thank you. I'll check it out and reply back to reward as due.
regards.