RE: SQL SERVER

I am not sure, but I think that in SQL Server there is no Archiver = process,
what you do is a "backup" of the transaction log (read: redo log file).

Then if the disk holding the transaction log has to be replaced, you = need to
restore that backup if you recover your database after a hardware = failure.

Also they keep stressing that setting autoextend for files saves the = DBA
from having to extend files all the time, but beware of this (as you = should
in Oracle) because the transaction log can grow and grow and grow and = ...

Then to reduce its size you will have to back it up, and truncate the transaction log. It won't happen right away, I think you have to wait = until
the next checkpoint for the log to shrink back to a reasonable size.

The SQL Server command syntax is different from Oracle's, but you will = get
used to that pretty quickly. Go go go ol=E9 ol=E9 ol=E9 (sorry, it's = early in
the morning)

Oh and as usual for Microsoft, a "device" is not a device, it's a = pointer to
a device. Like the printer in your Printers applet in Windows - = Microsoft
calls the printer icon and the code underlying it a "device" even = though you
need a REAL PRINTER to print. I don't know why they declared that a = little
bit of code is a device, makes no sense to me! Their focus is = obviously the
code they write, not the physical devices they are referring to. To = the
point where they forgot that the hardware actually does the work.

Regards,
Patrice Boivin
Systems Analyst (Oracle Certified DBA)

	-----Original Message-----
	From:	Christine Turner [SMTP:Christine.Turner_at_IPS-Sendero.com]
	Sent:	Tuesday, August 01, 2000 8:35 PM
	To:	Multiple recipients of list ORACLE-L
	Subject:	SQL SERVER

	Hello All.....

	I have rumors down the line that we are also going to start
developing and=20
	supporting Sql Server.  Anyone supporting both Oracle and Sql Server
now?=20
	 Comments, suggestions, knowing of whether or not I'm going to a
straight=20
	jacket????

	Thanks In Advance.
	Take Care,
	Christine Turner
	Database Administrator
	IPS-Sendero
	Scottsdale, Arizona
	Phone:  (800) 321-6899 ext. 3286
	Fax:      (480) 946-8224
	E-mail:  christine.turner_at_ips-sendero.com


	--=20
	Author: Christine Turner
	  INET: Christine.Turner_at_IPS-Sendero.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