When I create the database I receive a continuous "loading" by the name. Does anyone know how to cure this? Thanks
Phil Blancett Owner
Black Oak Computers/Oakweb
(916) 542-4209
(916) 542-0391 Fax
http://www.oakweb.com
-----Original Message-----
From: David Khoury [SMTP:dave@flex.com.au]
Sent: Friday, June 13, 1997 10:32 AM
To: emerald@emerald.iea.com
Subject: Re: moving Emerald database
>I set up SQL Emerald on a test server so our accounting dept. could check
>it out and before I knew they had 500 accounts put in. This being a test
>server there is only a 600mb drive thats out of space and they don't want
>to enter the information in again.
>How do I move the database or back it up and restore it I know little about
>SQL.
The easiest way to move it is to just do a transfer. With Enterprise
Manager, reate an Emerald database on your new server, right click it,
select "Transfer", select the right Server/Database in the Source section,
then start the thing.
DONT start the transfer from the source server. Start it from the
destination. I don't know if this is a bug, but when I did this once, all
the data was erased from my SQL server and nothing was transferred to my
destination. And I double checked everything before I clicked on the
transfer button. Luckily I did a manual dump of the database only a few
hours before.
--------------------------------------#------------------------------------
David Khoury | "Where's the KABOOM ??
Technical Manager & Comms Engineer | There was supposed to be an
dave@flex.com.au | earth shattering KABOOM!!"
http://www.flex.com.au/~dave | Marvin the Martian
--------------------------------------#------------------------------------
----------------------------------------------------------
Emerald Mailing List listserver@emerald.iea.com
------ =_NextPart_000_01BC7B21.9841D640
Content-Type: application/ms-tnef
Content-Transfer-Encoding: base64
eJ8+IgcMAQaQCAAEAAAAAAABAAEAAQeQBgAIAAAA5AQAAAAAAADoAAEIgAcAGAAAAElQTS5NaWNy
b3NvZnQgTWFpbC5Ob3RlADEIAQ2ABAACAAAAAgACAAEEkAYAwAEAAAEAAAAQAAAAAwAAMAIAAAAL
AA8OAAAAAAIB/w8BAAAATQAAAAAAAACBKx+kvqMQGZ1uAN0BD1QCAAAAAGVtZXJhbGRAZW1lcmFs
ZC5pZWEuY29tAFNNVFAAZW1lcmFsZEBlbWVyYWxkLmllYS5jb20AAAAAHgACMAEAAAAFAAAAU01U
UAAAAAAeAAMwAQAAABgAAABlbWVyYWxkQGVtZXJhbGQuaWVhLmNvbQADABUMAQAAAAMA/g8GAAAA
HgABMAEAAAAaAAAAJ2VtZXJhbGRAZW1lcmFsZC5pZWEuY29tJwAAAAIBCzABAAAAHQAAAFNNVFA6
RU1FUkFMREBFTUVSQUxELklFQS5DT00AAAAAAwAAOQAAAAALAEA6AQAAAB4A9l8BAAAAGAAAAGVt
ZXJhbGRAZW1lcmFsZC5pZWEuY29tAAIB918BAAAATQAAAAAAAACBKx+kvqMQGZ1uAN0BD1QCAAAA
AGVtZXJhbGRAZW1lcmFsZC5pZWEuY29tAFNNVFAAZW1lcmFsZEBlbWVyYWxkLmllYS5jb20AAAAA
AwD9XwEAAAADAP9fAAAAAAIB9g8BAAAABAAAAAAAAALpXwEEgAEAHAAAAFJFOiBtb3ZpbmcgRW1l
cmFsZCBkYXRhYmFzZQCwCQEFgAMADgAAAM0HBgARAA0AFwAGAAIAFwEBIIADAA4AAADNBwYAEQAN
ABUALwACAD4BAQmAAQAhAAAAMkEyQTZCRTBFRUU2RDAxMUEyQzEwMEEwQzkwNjczRUQAOwcBA5AG
AOQIAAAhAAAACwACAAEAAAALACMAAAAAAAMAJgAAAAAACwApAAAAAAADAC4AAAAAAAMANgAAAAAA
QAA5ANCr3TUZe7wBHgBwAAEAAAAcAAAAUkU6IG1vdmluZyBFbWVyYWxkIGRhdGFiYXNlAAIBcQAB
AAAAFgAAAAG8exk1t+BrKivm7hHQosEAoMkGc+0AAB4AHgwBAAAABQAAAFNNVFAAAAAAHgAfDAEA
AAAQAAAAUGhpbEBvYWt3ZWIuY29tAAMABhCl/qtzAwAHEM0FAAAeAAgQAQAAAGUAAABXSEVOSUNS
RUFURVRIRURBVEFCQVNFSVJFQ0VJVkVBQ09OVElOVU9VUyJMT0FESU5HIkJZVEhFTkFNRURPRVNB
TllPTkVLTk9XSE9XVE9DVVJFVEhJUz9USEFOS1NQSElMQkxBAAAAAAIBCRABAAAAzAUAAMgFAAAi
CgAATFpGddsd7j13AAoBAwH3IAKkA+MCAGOCaArAc2V0MCAHE08CgwBQDv8HEyBCC2BjCmsCgzIQ
vyBGdXSRCHBhIFgSMGtDA6AUQlQCgzMS53BycZoyD/Z9CoAIyCA7CW+YMjU1AoAKgXVjAFANCwNj
AEELYG5nMTBGMxVRC8QgV2gJ8CAESSAFAGVhdGUgsnQbICBkG7ABoGEPsMMbUQlwY2VpdhvQFFC3
BaACMAuAdQhgBCAiCQAEYWQLgGciIGJ5CRvjbmEHgC4gIEQ2bweRAHB5AiAb0Gtuym8H4GggkXRv
G3AIcCsb0gQAPx+QVA+Abmt/ERAKsQqECoQZogLREKIx2DcgUCGQEhNuHQACQOggT3cgQHIiVBIz
JQBmYSYACFBtcBQQBJBzMi8mIXdlDDAiYyg5ADE2KSA1NDIteSgwMDknbhpQJ9AT8GFWeCJVGcJ1
AyBoAkBw0DovL3crcC4eUCci+i4FoG0jYyrQAtES0CLLhxChC8Uib2xpMzYBQMsjchXwbxvAY3QV
NCfg1CAtMTJPBRBnC4ASAcJNB5BzYWdlMTMudg8wRC5jCzEwRmktMTTGNAFAL5AxODABQAzQrTTT
YhPwA2E6DINiD+CARGF2aWQgSyDAAwhwHuBbU01UUDqDHDAdMEBmbGV4LBLwLmF1XS51NgAGYAIw
BzZnNiA3IGF5LCBKEnUgQTEzOvAxOTlTJBAaQDozFiFNOTdUGm82Z2UHgBRAbGRANT21LgiQYSwT
OUd1YoZqMHE2Z1JlOiAEYPM3EBogIEU9xBwnMt8z6jcvlC4PCoA+G2APsSB18nAGAFFMQVcCIB1R
G8C2cwVAD7ByHTAFwHMhEPsIYR1QYwWgOyAdsUFAAQC/BTAfgEjBQbEPcAWQa0VlvmkFQAhgBUAA
cDcwYgEQ/wWwHKIgcAfRG/Ee4A+ANzDeNTVgSJYEICaRIAuAH4D/IfAEAEtxQSJHVEVlR8Ub8Xch
UU5hAiBsHuAUUC/AMP8G0BwgBRAdMRvwG7BQoUsRfG9mReAKsB0ASzNMY2T1AiAnBUB3AHBPRiEB
OdH/UARN8UuhAMAdsEchC4AdUOpnC3EuRWVIIJFTsBtR/0DxG90FsRxwJfFK0UYxS0L/CXBHkEuy
StFL8iCRL5ACQP84gB1QBuAUEEVlRmEfgS56/yHSG9AboACQR4JUEB7hIRDvV+NK0U5hIQFqHgAF
QFeRt0dRFEAAgGYEkB+BV0rQvmhBUFUCFfAEAEJVTQBw/TJRcjrwG5QDkUFuRxIgIP9IcUwiR8Ri
0TGgKwAbcC+QfVlTLC50D7A4gDCAHiBU/WB1IjrwZyUb8mXUBmFH8d4vNvAcVVZRG/JTCGFS8f8P
sDCAVhFmtRvxA6BHkArAH2ikIYEaIFbVXTZET072VGxqYHUgA1Ib40gwavX7R+IfgVNsg0rRb9Yu
dAEA/0eQMcFWAh+BG2BTtCBzBpDHIXNQghRQYnVnOvB1UP9T8RskHnBTQlCTHQA68AdA/wlQa9Yc
I1QBBCA90Q+wNzD9b9NtHuBGYkfFS0IggG0Tb3hTYGYJcV6jeXJ/H4FBv0tRc7I/wFuBShN44WVH
8f55eqRLh2YzeOFHIXJHb0fXdaEhAHNyTBkwawMQHuCXdjQUUAOBdRIBZHUmgO9Sglg8UNRgsHcu
dDdiTnK/S6JW1VzFMTOIL4k+I4k/v4tfMrYfkTcKjd+ORHwfkDYiGxEJcCdfcRwBS0GAQk9PTSA/
P103NQWQaAMAYzHiYnQgJv0mUm0EIGFgMbEJ4AXAj0KXXaIhUXhic0YwcG940v8hAUuAH/FdNjgu
jk+PJB+Q9xugACBhQHNSASaxQSKQVHghISJdNiqPK5A4eS/+fjgiLFaXzJdIYmBH4Gpl/58BHbCV
douPoY+KD6OvjCv/XNukL6dvqH+MLEFmYmADEP1BIkwEAAVAl0kvkEeQR8QXPi8uiRaxAK8QAwAQ
EAAAAAADABEQAAAAAAMAgBD/////QAAHMACl6AYZe7wBQAAIMACl6AYZe7wBCwAAgAggBgAAAAAA
wAAAAAAAAEYAAAAAA4UAAAAAAAADAAKACCAGAAAAAADAAAAAAAAARgAAAAAQhQAAAAAAAAMABYAI
IAYAAAAAAMAAAAAAAABGAAAAAFKFAAC3DQAAHgAlgAggBgAAAAAAwAAAAAAAAEYAAAAAVIUAAAEA
AAAEAAAAOC4wAAMAJoAIIAYAAAAAAMAAAAAAAABGAAAAAAGFAAAAAAAACwAvgAggBgAAAAAAwAAA
AAAAAEYAAAAADoUAAAAAAAADADCACCAGAAAAAADAAAAAAAAARgAAAAARhQAAAAAAAAMAMoAIIAYA
AAAAAMAAAAAAAABGAAAAABiFAAAAAAAAHgBBgAggBgAAAAAAwAAAAAAAAEYAAAAANoUAAAEAAAAB
AAAAAAAAAB4AQoAIIAYAAAAAAMAAAAAAAABGAAAAADeFAAABAAAAAQAAAAAAAAAeAEOACCAGAAAA
AADAAAAAAAAARgAAAAA4hQAAAQAAAAEAAAAAAAAAHgA9AAEAAAAFAAAAUkU6IAAAAAADAA00/TcA
AIdl
------ =_NextPart_000_01BC7B21.9841D640--