Correct.
SQL Server can have multiple transaction logs (I discovered this last week
while reading so I am correcting a previous post of mine here), but these
inevitably fill up. You then either do a backup log filename to device
truncate only to clear the log. This is the equivalent of running in
noarchivelog mode and using cold backups only.
If you want to keep backups of the transactions, you have to set up jobs to
back up the transaction log files regularly. After the backup is done, SQL
Server can remove transactions that were backed up from the log(s), clearing
up some space inside the file.
In Oracle, the ARCH process reads the redo logs and stores copies of the
contents into archived log files. You don't have to worry about the redo
log files filling up, but the archlog_dest directory can fill up.
You can set the SQL Server transaction log to autoextend, until the disk
fills up... which is kind of like running out of space in archive log dest.
Sort of.
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: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED]
-Original Message-
From: Gary Weber [SMTP:[EMAIL PROTECTED]]
Sent: Wednesday, May 30, 2001 3:42 PM
To: Multiple recipients of list ORACLE-L
Subject:OT: Archiving not possible with SQL Server?
Halo,
Windoz 2000/SQL Server 2000
Bringing an axuliary MS SQL db online. Trying to setup archiving.
Am I
reading documentation right, SQL does NOT automatically archive
transaction
log? This process must be setup via backup routine, which truncates
the log
upon completion?
Lemme try some logic:
Oracle's redo logs = MS transaction log(s)
Oracle's archived logs = ?
Gary Weber
Senior DBA
Charles Jones, LLC
609-530-1144, ext 5529
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Gary Weber
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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: Boivin, Patrice J
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
