| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Archiving not possible with SQL Server?
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: boivinp_at_mar.dfo-mpo.gc.ca <mailto:boivinp_at_mar.dfo-mpo.gc.ca>
-----Original Message-----
From: Gary Weber [SMTP:gweber_at_cji.com]
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: 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).
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Liststo: 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). Received on Wed May 30 2001 - 14:03:56 CDT
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
 |
 |