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 |
|
vna_mhars
Starting Member
37 Posts |
 Posted - 2011-05-31 : 01:59:11
|
| Hi, I want to have a mirror copy of my database (90Gb). I tried to set up a replication (p2p transactional replication) which is not possible due to the primary keys that are not setup during the initialization of the database.I am new from this company so that I was not happy to know that the structure of the database is like this. For now i need a suggestion from the expert, help me the best idea to have a fail over just incase the problem occur. it was also comes to my mind to add another axtra field for the primary key but it is not possible due to the design of the programs that are currently running. Thanks in advance. Vernodvamodente |
|
|
nirangava
Starting Member
4 Posts |
Posted - 2011-05-31 : 03:04:13
|
| try to get a snap shot of the data base it'll work for you... |
 |
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2011-05-31 : 03:39:06
|
| Snapshots are not mirrors and they are not failover copies.vamodente, have you considered database mirroring?--Gail ShawSQL Server MVP |
|
|
|
vna_mhars
Starting Member
37 Posts |
Posted - 2011-05-31 : 05:20:05
|
| Not yet.. I tried only the Peer to Peer Replication because the management wants the database to be synchronize. once there's a new transaction it will also update the replicated database. Do you have a nice step by step to do the mirroring and the requirements of it ..My idea is having 2 servers and 1 Thank you very much .vamodente |
|
|
|
|
|
|
SQL2005 database mirror copy