Tillbaka till svenska Fidonet
English   Information   Debug  
OS2BBS   0/787
OS2DOSBBS   0/580
OS2HW   0/42
OS2INET   0/37
OS2LAN   0/134
OS2PROG   0/36
OS2REXX   0/113
OS2USER-L   207
OS2   0/4779
OSDEBATE   0/18996
PASCAL   0/490
PERL   0/457
PHP   0/45
POINTS   0/405
POLITICS   0/29554
POL_INC   0/14731
PSION   103
R20_ADMIN   1117
R20_AMATORRADIO   0/2
R20_BEST_OF_FIDONET   13
R20_CHAT   0/893
R20_DEPP   0/3
R20_DEV   399
R20_ECHO2   1379
R20_ECHOPRES   0/35
R20_ESTAT   0/719
R20_FIDONETPROG...
...RAM.MYPOINT
  0/2
R20_FIDONETPROGRAM   0/22
R20_FIDONET   0/248
R20_FILEFIND   0/24
R20_FILEFOUND   0/22
R20_HIFI   0/3
R20_INFO2   2632
R20_INTERNET   0/12940
R20_INTRESSE   0/60
R20_INTR_KOM   0/99
R20_KANDIDAT.CHAT   42
R20_KANDIDAT   28
R20_KOM_DEV   112
R20_KONTROLL   0/13030
R20_KORSET   0/18
R20_LOKALTRAFIK   0/24
R20_MODERATOR   0/1852
R20_NC   76
R20_NET200   245
R20_NETWORK.OTH...
...ERNETS
  0/13
R20_OPERATIVSYS...
...TEM.LINUX
  0/44
R20_PROGRAMVAROR   0/1
R20_REC2NEC   534
R20_SFOSM   0/340
R20_SF   0/108
R20_SPRAK.ENGLISH   0/1
R20_SQUISH   107
R20_TEST   2
R20_WORST_OF_FIDONET   12
RAR   0/9
RA_MULTI   106
RA_UTIL   0/162
REGCON.EUR   0/2055
REGCON   0/13
SCIENCE   0/1206
SF   0/239
SHAREWARE_SUPPORT   0/5146
SHAREWRE   0/14
SIMPSONS   0/169
STATS_OLD1   0/2539.065
STATS_OLD2   0/2530
STATS_OLD3   0/2395.095
STATS_OLD4   0/1692.25
SURVIVOR   0/495
SYSOPS_CORNER   0/3
SYSOP   0/84
TAGLINES   0/112
TEAMOS2   0/4530
TECH   0/2617
TEST.444   0/105
TRAPDOOR   0/19
TREK   0/755
TUB   0/290
UFO   0/40
UNIX   0/1316
USA_EURLINK   0/102
USR_MODEMS   0/1
VATICAN   0/2740
VIETNAM_VETS   0/14
VIRUS   0/378
VIRUS_INFO   0/201
VISUAL_BASIC   0/473
WHITEHOUSE   0/5187
WIN2000   0/101
WIN32   0/30
WIN95   0/4275
WIN95_OLD1   0/70272
WINDOWS   0/1517
WWB_SYSOP   0/419
WWB_TECH   0/810
ZCC-PUBLIC   0/1
ZEC   4

 
4DOS   0/134
ABORTION   0/7
ALASKA_CHAT   0/506
ALLFIX_FILE   0/1313
ALLFIX_FILE_OLD1   0/7997
ALT_DOS   0/152
AMATEUR_RADIO   0/1039
AMIGASALE   0/14
AMIGA   0/331
AMIGA_INT   0/1
AMIGA_PROG   0/20
AMIGA_SYSOP   0/26
ANIME   0/15
ARGUS   0/924
ASCII_ART   0/340
ASIAN_LINK   0/651
ASTRONOMY   0/417
AUDIO   0/92
AUTOMOBILE_RACING   0/105
BABYLON5   0/17862
BAG   135
BATPOWER   0/361
BBBS.ENGLISH   0/382
BBSLAW   0/109
BBS_ADS   0/5290
BBS_INTERNET   0/507
BIBLE   0/3563
BINKD   0/1119
BINKLEY   0/215
BLUEWAVE   0/2173
CABLE_MODEMS   0/25
CBM   0/46
CDRECORD   0/66
CDROM   0/20
CLASSIC_COMPUTER   0/378
COMICS   0/15
CONSPRCY   0/899
COOKING   27601
COOKING_OLD1   0/24719
COOKING_OLD2   0/40862
COOKING_OLD3   0/37489
COOKING_OLD4   0/35496
COOKING_OLD5   9370
C_ECHO   0/189
C_PLUSPLUS   0/31
DIRTY_DOZEN   0/201
DOORGAMES   0/1974
DOS_INTERNET   0/196
duplikat   5999
ECHOLIST   0/18295
EC_SUPPORT   0/318
ELECTRONICS   0/359
ELEKTRONIK.GER   1534
ENET.LINGUISTIC   0/13
ENET.POLITICS   0/4
ENET.SOFT   0/11701
ENET.SYSOP   33773
ENET.TALKS   0/32
ENGLISH_TUTOR   0/2000
EVOLUTION   0/1335
FDECHO   0/217
FDN_ANNOUNCE   0/7068
FIDONEWS   23436
FIDONEWS_OLD1   0/49742
FIDONEWS_OLD2   0/35949
FIDONEWS_OLD3   0/30874
FIDONEWS_OLD4   0/37224
FIDO_SYSOP   12841
FIDO_UTIL   0/180
FILEFIND   0/209
FILEGATE   0/212
FILM   0/18
FNEWS_PUBLISH   4155
FN_SYSOP   41520
FN_SYSOP_OLD1   71952
FTP_FIDO   0/2
FTSC_PUBLIC   0/13556
FUNNY   0/4886
GENEALOGY.EUR   0/71
GET_INFO   105
GOLDED   0/408
HAM   0/16041
HOLYSMOKE   0/6791
HOT_SITES   0/1
HTMLEDIT   0/71
HUB203   466
HUB_100   264
HUB_400   39
HUMOR   0/29
IC   0/2851
INTERNET   0/424
INTERUSER   0/3
IP_CONNECT   719
JAMNNTPD   0/233
JAMTLAND   0/47
KATTY_KORNER   0/41
LAN   0/16
LINUX-USER   0/19
LINUXHELP   0/1155
LINUX   0/22002
LINUX_BBS   0/957
mail   18.68
mail_fore_ok   249
MENSA   0/341
MODERATOR   0/102
MONTE   0/992
MOSCOW_OKLAHOMA   0/1245
MUFFIN   0/783
MUSIC   0/321
N203_STAT   894
N203_SYSCHAT   313
NET203   321
NET204   69
NET_DEV   0/10
NORD.ADMIN   0/101
NORD.CHAT   0/2572
NORD.FIDONET   189
NORD.HARDWARE   0/28
NORD.KULTUR   0/114
NORD.PROG   0/32
NORD.SOFTWARE   0/88
NORD.TEKNIK   0/58
NORD   0/453
OCCULT_CHAT   0/93
Möte OSDEBATE, 18996 texter
 lista första sista föregående nästa
Text 900, 107 rader
Skriven 2004-10-13 21:32:28 av Ellen K. (1:379/45)
Ärende: Re: Software Magnate gets spammed, 0wned; sees light
============================================================
From: Ellen K. <72322.enno.esspeeayem.1016@compuserve.com>

The log restores everything SINCE the last backup.

Or you can use it to roll back the database to before Something Terrible
happened.   (But I sure hope that never happens to me because I don't
actually know how to do it!)

On Wed, 13 Oct 2004 06:14:01 -0500, "Geo" <georger@nls.net> wrote in message
<416cff2d$1@w3.nls.net>:

>Guess our views differ, I see the log as a simple undo mechanism incase a
>transaction fails to complete, restore is done from backup.
>
>Geo.
>
>"Ellen K." <72322.enno.esspeeayem.1016@compuserve.com> wrote in message
>news:rpgnm0pn9v8eeiotk5rlo2aevih2f6j0pa@4ax.com...
>> That kills your ability to restore from the log.
>>
>> On Mon, 11 Oct 2004 22:58:54 -0500, "Geo" <georger@nls.net> wrote in
>> message <416b480d$1@w3.nls.net>:
>>
>> >right click on the database, pick properties
>> >
>> >on the options tab select "select into/bulk copy" and "truncate log on
>> >checkpoint"
>> >
>> >Geo.
>> >
>> >"Glenn Meadows" <gmeadow@comcast.net> wrote in message
>> >news:416ab48a@w3.nls.net...
>> >> Speaking or Transaction Log, I've been unable to successfully get that
>log
>> >> to auto maintain itself using SQL manager.  We go bopping along fine
>for
>> >> some time, I keep checking it's size on it's separate 36gig array, and
>> >just
>> >> when they start processing the end of month, or so, BOOM, it fills up,
>and
>> >> won't let anyone access the system, till BACKUP the transaction log,
>then
>> >> SHRINK the database.  Very frustrating. (Luckily, I THINK, we'll be off
>> >this
>> >> system in the next few months).  That's going to give me a nice 8 way
>Dell
>> >> server to play with (if we keep it, which I'm lobbying for, converting
>it
>> >to
>> >> our primary file sever <smile>).
>> >>
>> >> --
>> >> Glenn M.
>> >>
>> >>
>> >> "Ellen K" <Ellen.K@harborwebs.com> wrote in message
>> >> news:808710.4b1c2e@harborwebs.com...
>> >> > Disk I/O is way more important for database performance than CPU
>speed.
>> >> Just
>> >> > putting the transaction log on its own array speeds things up
>> >> considerably.
>> >> >
>> >> >
>> >> > > From: "Geo." <georger@nls.net>
>> >> > > It doesn't limit the log to 250K rows, it limits each field to X
>> >> characters.
>> >> > >The 250K limit is because there are time sensitive queries goin on
>in
>> >> order to
>> >> > > filter the spam, too much time and things start to break so they
>> >limited
>> >> the
>> >> > > log to a rotating 250K lines, add a line and a line pops off the
>other
>> >> end.
>> >> > > I imagine the faster the box the bigger this limit (it is 250K on
>> >their
>> >> model
>> >> > > 400, the 600 may allow more I dunno but it has a faster cpu).
>> >> > > Geo.
>> >> > > "Ellen K." <72322.enno.esspeeayem.1016@compuserve.com> wrote in
>> >message
>> >> > > news:idnhm0h7icvfgg5jcocqp3r8lrten6d4m6@4ax.com...
>> >> > >> Why would using a SQL database limit the log to 250,000 rows?   I
>> >have
>> >> > >> about 27 million rows in my biggest table.
>> >> > >>
>> >> > >> On Sat, 9 Oct 2004 21:30:38 -0400, "Geo." <georger@nls.net> wrote
>in
>> >> > >> message <41688f87$1@w3.nls.net>:
>> >> > >>
>> >> > >>>That could be a problem, they use an sql database to hold the
>message
>> >> log so
>> >> > >> >you only get the last 250,000 connect attempts logged and however
>> >many
>> >> > >> >characters.
>> >> > >>
>> >>
>> >>
>> >
>>
>

--- BBBS/NT v4.01 Flag-5
 * Origin: Barktopia BBS Site http://HarborWebs.com:8081 (1:379/45)