Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Replicating a database in sql2000
We are trying to replicate databases on windows 2000. We were thinking of just doing dumps and restores on the other server daily, but I was wondering if there are better alternatives. This is a special project I was given, and I'm not an sql admin by any means, but I would like to offer the...- flyjetta
- Thread
- Replies: 2
- Forum: Microsoft SQL Server: Programming
-
SQL 2000 Replication
How would I replicate data from one sql server to another? We are setting up two identical boxes for a client, they would like some form of failover if possible. We were thinking of doing a dump every night, then exporting that data to the other server and doing a restore. Any suggestions on...- flyjetta
- Thread
- Replies: 1
- Forum: Microsoft SQL Server: Setup and Administration
-
Restore database from a dump on another server
I was wondering if it is possible to restore a dump from a different sql server? We are going to have 2 sql 2000 servers on the same network. One will be the original and will create the dump files at night. We would like the other one to then restore the dump files in it's database so they...
