Monday, March 26, 2012

Recovery and Backup

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

ThanksI 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/techin...vailability.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/res...10g_compare.pdf

Simonsql

No comments:

Post a Comment