daiwhyte
asked on
Goldmine Setup Problems
Ive setup a goldmine instance to test our DR but their appears to be quite a bit of difference between the two setups in terms of what the user see's when they log in.
It looks like our live setup has been customised, the contact windows at the top are different for starters .
How can I copy over the customization from our live server to our DR test?
Thanks
It looks like our live setup has been customised, the contact windows at the top are different for starters .
How can I copy over the customization from our live server to our DR test?
Thanks
ASKER
Hi Stephen, not sure that comment was meant for me?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Ive created a backup of the live sql database, Im just in the process of uploading the file to my test server and then will restore and clear out the live data.
Keep you posted guys.
Keep you posted guys.
quickest way to clear down the data on a test system is to truncate the correct tables
truncate table contact1
contact2
contsupp
conthist
contgrps
cal
mailbox
opmgr
opmgrfld
gsserver
gssites
gsfilter
gmtlog
conttlog
syslog
truncate table contact1
contact2
contsupp
conthist
contgrps
cal
mailbox
opmgr
opmgrfld
gsserver
gssites
gsfilter
gmtlog
conttlog
syslog
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Be sure to tick the overwrite database on the options page
Try the "from device" option, rather than "from database"
What version of SQL is it? 2005 or 2008?
Ensure you tick Overwrite and ensure the "Restore As" path is the test system MDF / LDF location
2005 leaves the restore as to the origincal path, 2008 tends to do it write :-)
ScreenHunter-01-Oct.-30-14.59.gif
ScreenHunter-02-Oct.-30-14.59.gif
Ensure you tick Overwrite and ensure the "Restore As" path is the test system MDF / LDF location
2005 leaves the restore as to the origincal path, 2008 tends to do it write :-)
ScreenHunter-01-Oct.-30-14.59.gif
ScreenHunter-02-Oct.-30-14.59.gif
ASKER
Ok, got it chaps, I think it was a combination of your comments which got me there. Can we split?
Sure.
no probs with me, your choice at the end of the day :-)
ASKER
Thank you all.
c:\goldmine\gmw7.exe /g:alias /c: alias
This will cause both sets of tables (gmbase and contacts) to both come from the same db. If your test db is using the production db for its gmbase tables... watch out!!!