RE: OT: Archiving not possible with SQL Server?

Bet you aren't an idiot: bet you're suffering from Microsoft-induced aphasia.
I hate MS's habit of taking perfectly good industry vocabulary and making the words mean too-specific proprietary things. Works in MS's favor: helps the MSCEs makes the rest of the world feel like idiots!

As far as the archiving, I curse both houses Oracle and Microsoft. On my old RDB (when it was Digital) database, I could take a reliable fast full backup any old time, and throw away any old backups that I'd created before. Not like Oracle where I have to quilt together old redo logs/datafiles or SQL Server where I have to keep all of the silly transaction logs to make any kind of reliable copy.

Before you flame: yes I could quilt together RDB with the After-Image Journals, and I could take am Oracle backup with export/import or use a fancy Sql Server utility and have a semi-reliable backup. I'm only arguing that the scale of work associated with the task at hand seemed much more appropriate in RDB. 'Course RDB ran on proprietary operating system OOPS! start a new flame!

-----Original Message-----
Sent: Thursday, May 31, 2001 9:41 AM
To: Multiple recipients of list ORACLE-L

Yeah? But you know what? After few hours with SQL manual I'm starting to feel like an idiot.

Supreme Council says: "All Aboard MS SQL!" Me says: "Abandon Ship!"

Gary Weber
Senior DBA
Charles Jones, LLC
609-530-1144, ext 5529

-----Original Message-----
Patrice J
Sent: Thursday, May 31, 2001 7:35 AM
To: Multiple recipients of list ORACLE-L

Jared is having a bad day.

: )

Patrice Boivin
Systems Analyst (Oracle Certified DBA)

Systems Admin & Operations | Admin. et Exploit. des systèmes
Technology Services        | Services technologiques
Informatics Branch         | Direction de l'informatique
Maritimes Region, DFO      | Région des Maritimes, MPO

E-Mail: boivinp_at_mar.dfo-mpo.gc.ca <mailto:boivinp_at_mar.dfo-mpo.gc.ca>

        -----Original Message-----
        From:   Jared Still [SMTP:jkstill_at_cybcon.com]
        Sent:   Thursday, May 31, 2001 3:51 AM
        To:     Multiple recipients of list ORACLE-L
        Subject:        Re: OT: Archiving not possible with SQL Server?


        Are you an idiot?

        Jared


        On Wednesday 30 May 2001 14:55, Gary Weber wrote:


        > >>Guess what happens when a long running transaction marks

        >

        > the log near the end, and not too long afterward the log

        > needs truncated? If memory serves, ( hasn't worked too well lately

:) the


        > database

        > will hang.  It may just truncate back to the mark, and start from

        > there, but you always have the possibility of another long

        > transaction starting.<<

        >

        > HELP

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Gary Weber
  INET: gweber_at_cji.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Shreter, Hilary
  INET: ShreterH_at_orau.gov

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).