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 |
|
anuj164
Starting Member
49 Posts |
 Posted - 2005-10-11 : 16:18:18
|
| How to Create Database Mirroring of same database but in different server and the updates should happen is both the databases. Like. we have one Main DB where the application is connected. We need to create the DB Mirroring and the any user updates the value in Main DB the mirroning DB should also be updated. But this Mirroring DB will be in diffrent DB Server. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2005-10-11 : 16:23:48
|
| You can use transactional replication if you need to use both databases.If you just want to mirror it for disaster recovery purposes, then you can use log shipping. In SQL Server 2005, we also get the database mirroring option but log shipping is still available.Tara |
 |
|
|
|
|
|
Database Mirroring