Theitman
25 pts. | Sep 11 2008 10:03PM GMT
If both servers are SQL 2005 then you must put one database into a restore mode. Go the main one and right click the database and tasks and click mirror then run configure security and make sure that the principle is the main database and the mirror is the database that is in restore mode and you may choose any witness.
Rockleadme
385 pts. | Sep 11 2008 11:25PM GMT
Thanks guys!!
big mistake ..i frogot to mention that these two boxes are AS400…and the libraries i was reffering to earlier —are actually data libraries.
So daily transaction data to be copied over to the development box (or is should rather say the test box) is what i want to do - in real time if easily possible or at the end of each day.
Tlrz
50 pts. | Sep 15 2008 5:38AM GMT
For AS400 world:
1) The perfect solution some of HA tools, but costs…
2) Writing your own mirroring solutions ( database trigger + data queue + remote data queues ) but time consuming , but almost real time.
3) SavRstLib or SavRstObj from OS400 ObjectConnect ( free of charge part of every purcharse) but is not a real time synchronization.
4) SavLib SavObj to SavFile + script for FTP to other system & QUOTE RCMD for restore…but not real time , but complicated
My tip for you is solution 3






