Recovery and Backup

[AP]

Could someone please give me an idea of the differences between SQL
Server and Oracle, backup and recovery options.

Thanks

[Simon Hayes]

I don't know Oracle, but I would assume that it supports the same
general features as MSSQL - full, differential and log backups, log
shipping, point-in-time recovery etc. The terminology may differ, and
since both products have very different architectures and storage
mechanisms, I'm sure the implementation of backup/recovery is different
in both cases anyway.

You can find more information about MSSQL here:

http://www.microsoft.com/sql/techinf...ailability.asp

This comparison of SQL2005 and Oracle appears to be more even-handed
and accurate than most; although I haven't read all of it, it does
cover backup/restore specifically:

http://www.wisdomforce.com/dweb/reso...0g_compare.pdf

Simon