Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
CanadaDBA
583 Posts |
 Posted - 2007-06-08 : 09:27:47
|
| Env. SQL 2000 Win 2003I want to replicate an instance of SQL Server to another machine. That instance has several DBs and number of DBs is being increased or decreased; i.e. today a new database might be added and tomorrow two DBs might be dropped. Can I implement replication in an instance level? What approach is suggested?The work is to have all the databases on one instance available on another machine. Since the databases are being added or dropped, the number of DBs is being changed everyday or couple of days. This is not a transactional environment. Maybe a simple solution is to backup and restore every night; i.e.1. Generate BAK files from Source server2. Drop databases on Dest server3. Restore BAK files into Dest serverThanks,Canada DBA |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-06-08 : 13:27:01
|
| Dup:http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=84753 |
 |
|
|
|
|
|
Replicate an instance