Mark,
There are few options I know about:
1) Put a tape drive in the SQL server and use the Back-Up function in =
SQL.
2) Use a third party software like BackupEXEC with the SQL module. This =
solution will run about $1,100.00. Ouch!
3) Use a batch file (or .cmd) to stop the service, backup the .DAT file, =
and then restart the service. I do something similar with Exchange =
Server once a week to back-up the total structure.
Hope this helps.
Regards,
Albert
----------
From: Mark A. Knight[SMTP:RadAdmin@Express-Connect.Net]
Reply To: emerald@emerald.iea.com
Sent: Thursday, June 12, 1997 3:56 AM
To: Emerald Mail-List (E-mail)
Subject: EMERALD.DAT Backup
Hello everyone,
I have a question that is probably basic SQL, but, I don't know the =
answer so I'm asking! I do daily backups of my servers, but, important =
files, like EMERALD.DAT are always skipped because they are open/in use.
How does one go about backing up the Emerald database on a regular =
basis? I recently got bit by not having a good backup and I don't EVER =
want that to happen again!
Thanks in advance.
NT 4.0 (Build 1381-SP3) - MS SQL Server 6.5 - RadiusNT V 1.16.60
Emerald Client 2.1.8 - Emerald Admin 2.1.0 - Serv-U V2.2 32 Bit
MailSite Version 1.2.2 - NAS Ascend MAX 4000
Mark A. Knight - PC Express, Inc=20
RadAdmin@Express-Connect.Net
----------------------------------------------------------
Emerald Mailing List listserver@emerald.iea.com
------ =_NextPart_000_01BC764B.2FE9FDA0
Content-Type: application/ms-tnef
Content-Transfer-Encoding: base64
eJ8+Ig8NAQaQCAAEAAAAAAABAAEAAQeQBgAIAAAA5AQAAAAAAADoAAEIgAcAGAAAAElQTS5NaWNy
b3NvZnQgTWFpbC5Ob3RlADEIAQmAAQAhAAAANzQzQzc1NkEyQ0UyRDAxMUEyMTcwMDAwQzBFQTRF
Q0YAHAcBBYADAA4AAADNBwYADAAJACQABQAEABwBASCAAwAOAAAAzQcGAAwACQAkAAUABAAcAQEE
kAYAYAEAAAEAAAAOAAAAAwAAMAAAAAALAA8OAAAAAAIB/w8BAAAATwAAAAAAAACBKx+kvqMQGZ1u
AN0BD1QCAAAAACdlbWVyYWxkQGVtZXJhbGQuaWVhLmNvbScAU01UUABlbWVyYWxkQGVtZXJhbGQu
aWVhLmNvbQAAHgACMAEAAAAFAAAAU01UUAAAAAAeAAMwAQAAABgAAABlbWVyYWxkQGVtZXJhbGQu
aWVhLmNvbQAeAAEwAQAAABoAAAAnZW1lcmFsZEBlbWVyYWxkLmllYS5jb20nAAAAAgH2DwEAAAAE
AAAAAAAAAAMAFQwBAAAAAgELMAEAAAAdAAAAU01UUDpFTUVSQUxEQEVNRVJBTEQuSUVBLkNPTQAA
AAAeACA6AQAAABoAAAAnZW1lcmFsZEBlbWVyYWxkLmllYS5jb20nAAAACwBAOgEAAAADAP4PBgAA
AAMAADkAAAAAAwBxOgAAAADHQwENgAQAAgAAAAIAAgABBIABABcAAABSRTogRU1FUkFMRC5EQVQg
QmFja3VwAGgGAQOQBgDcCAAAHgAAAAsAIwABAAAACwApAAAAAAADACYAAAAAAAMANgAAAAAAAwAu
AAAAAAAeAEIQAQAAADcAAAA8MDlBRDkxM0E1RURDRDAxMUEyMTUwMDAwQzBFQTRFQ0ZCM0BzcWwy
LmRpYWxpc2RuLm5ldD4AAAIBCRABAAAANAUAADAFAAB2CQAATFpGdWbtl7YDAAoAcmNwZzEyNf4y
AP8CBgKkA+QF6wKDAFATA1QCAGNoCsBzZXT+MgYABsMCgw5QA9UHEwKDujMTzX0KgAjPCdk7Fr+9
DjA1AoAKgQ5xC2BuDhAUMDMU4GgFsHpkb2pjAAAqElUgApEawGzvGvUK+xOyDAFjAEAF0ArATGss
CoUKhVRoBJBlViAKwB8QZgfRbwUwaYMCIAQgSSBrbm8H4BMBoAhgdDod/DEpIFZQINAfICABkHAf
EGR9BRB2HxALgCJgHuAGAFF0TCASsHIi8AXAAHBkLCB1ErAjQ0IA0GstxFVwH2B1bmMf0iMS1SOR
Lh38MiHwVSSRIlGUaGkLICAKsXR5I8CKbwGAdx8ybGlrJOSAdXBFWEVDIAPwhyNQI0cEYXVsZS4e
wV8EACihCkAlwwPwbAMgckMlkCCUICQxLBngMKIuLaEgT3UScCEd/OIzJ3ZiYXQScB9gAxCFHxAo
BbEuY21kIfD8dG8jwDEgJWAjUiPSDeAcZSwvwSmyI0MuREH+VDAjMlAkQiNRA6AWwDFQ/yhhMZor
cCAwGnAooQeAJ/E/GcAjwAdwAxAKwSpDRXh/EnEZwCNxI+QCIDIwIkF37QngazESMnItMrUxIAGQ
fwMgMVAswCWwCHArYB38SI8fsCSiK7Ee4GxwcyZ9KFJlZwsRcx3mQWw6YgSQdB38CospQDE4gy2g
AgBpLTE0NA6wvwzQQYMLWUEACqADYHQFkH0FQC1DpwqHQlsMMEMmRv0DYTpErkMmDIIdkxQwK3AC
SwMAZ2h0W1NNAFRQOlJhZEFkOTbAbkA3cEMgB5BzLSkIUG5uQ2EuB8B0XZ9ET0VdPeALUCiQVG9G
j5VHm2UHgHIHQGRAT9X6LgiQYTDAA3BLf0VdBmAfAjBN/0ebHtAIcHNkYXp5MlBKJZAfEA4gMlAx
iDk5Ny8wOjU2FDDeTVFPRV1N30d9RU/kHZEZAxAtTAQABUAoRS0bAMADEClXX1JedWJqB0NhWX9a
jE1FUkFMnkQzIymUP69AszM2Qif3FOIMAUMmSDywFlBPwCQB/nkCIDJAHfwgMBKAIvEiUP5xClAx
UCXSI1Av4CMQBCD/QyEv0AJgKJAv0A3RI4IyUecg0DJQNbJuJwVAIFMjUp8AcTjgBcAosCAgJ20f
IORzazZhISA1pFWwAxD/aUIpsgQgKMArACiRI+M+QPtqBAdwcBZhAHAFQDAybtHfKUNhSh8yB0Ao
8HkrwWxwznAikCRgPvBjYSSFKJDzHzI8EW4vIyEkgTsfB+DnGnAHkWYRIGcxMC0EMnL/NmIytVtW
VbABkWlwc5Es4Z00UWcrQArBaWJzP2zC/xbAMjACME2hdiB2kSpQL8D/KJAgYAVAZ1E2YiJQdiAE
cOcyZiRCamZFVmFgKjBvsv9oUzEhEoByUSzhPgALgC5dux7QAHBrBCAjIUmwdgBwazVxHfxOM1A0
LcAwcEIGdQMQJGAxMzgxLXRTUC9BLQXTI6E4BTZsLjWD8UmhaSSAgoFW+SHQLjGFAGPQCoWG4VtW
nkMpQFNRJ1CGIC44g/H/W1ZJ04gDgtCEADgCJUCF4OuIEBLgMxLgQipQhoiLeu1b0lMqUB8QVm6x
JdKGENOKcoQATkEF8EEE8Anw+VuxQViCoC2ghnmPz4wW+0iKg/FQKiBKNWpBJaAeVv+Tv5BGSa9K
uT8/l79swEOo/5nvmv+b7IaGW1o2YlwjkEn/KUAxUCPUUE9i7xx9QyYKhQUV4QCkUB4AcAABAAAA
FwAAAFJFOiBFTUVSQUxELkRBVCBCYWNrdXAAAAIBcQABAAAAFgAAAAG8dmy12ckPmRbiXRHQupUA
AMDeV+0AAEAAOQDIiuqTNXe8AQMA8T8JBAAAHgAeDAEAAAADAAAARVgAAB4AHwwBAAAATwAAAC9P
PVZJUlRVQUwgQlJPQURDQVNUIE5FVFdPUkssIElOQy4vT1U9VkJORVRXT1JLL0NOPURJQUxJU0RO
L0NOPUFMQkVSVEBESUFMSVNETgAAAwAZQAAAAAADAP0/5AQAAAIB+T8BAAAAawAAAAAAAADcp0DI
wEIQGrS5CAArL+GCAQAAAAAAAAAvTz1WSVJUVUFMIEJST0FEQ0FTVCBORVRXT1JLLCBJTkMuL09V
PVZCTkVUV09SSy9DTj1ESUFMSVNETi9DTj1BTEJFUlRARElBTElTRE4AAB4A+D8BAAAADgAAAEFs
YmVydCBDaHVyYmEAAAACAfs/AQAAAGsAAAAAAAAA3KdAyMBCEBq0uQgAKy/hggEAAAAAAAAAL089
VklSVFVBTCBCUk9BRENBU1QgTkVUV09SSywgSU5DLi9PVT1WQk5FVFdPUksvQ049RElBTElTRE4v
Q049QUxCRVJUQERJQUxJU0ROAAAeAPo/AQAAAA4AAABBbGJlcnQgQ2h1cmJhAAAAQAAHMMiK6pM1
d7wBQAAIMCLt7JM1d7wBHgA1EAEAAAA5AAAAPDA5QUQ5MTNBNUVEQ0QwMTFBMjE1MDAwMEMwRUE0
RUNGMjlCMEBzcWwyLmRpYWxpc2RuLm5ldD4AAAAAAwAGEGoLFOcDAAcQdAQAAAMAEBAAAAAAAwAR
EAAAAAAeAAgQAQAAAGUAAABNQVJLLFRIRVJFQVJFRkVXT1BUSU9OU0lLTk9XQUJPVVQ6MSlQVVRB
VEFQRURSSVZFSU5USEVTUUxTRVJWRVJBTkRVU0VUSEVCQUNLLVVQRlVOQ1RJT05JTlNRTDIpVVNF
QVRIAAAAAAMADTT9PwAAAgEUNAEAAAAQAAAAVJShwCl/EBulhwgAKyolFx4APQABAAAABQAAAFJF
OiAAAAAARJI=
------ =_NextPart_000_01BC764B.2FE9FDA0--