Oracle FAQ Your Portal to the Oracle Knowledge Grid

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Rman equivalent for MS-SQL server

RE: Rman equivalent for MS-SQL server

From: Mark Leith <>
Date: Tue, 16 Sep 2003 03:04:24 -0800
Message-ID: <>

You can actually use Database Maintenance Plans, to mimic RMAN to a certain extent. Database Maintenance Plans is basically a wizard that generates a load of MSDB jobs that get run by the SQL*Agent. This does have some limitations though. It has no support for differential backups, doesn't support appended backups to an already existing "device", you can't duplex back up files, and a number of the backup options aren't available.

This is described in some detail in "SQLServer for Oracle DBAs" an e-book that I would highly recommend to all primarily Oracle DBAs that have to do a certain amount of SQLServer work too.

HTH Mark

 Mark Leith             | T: +44 (0)1905 330 281
 Sales & Marketing      | F: +44 (0)870 127 5283
 Cool Tools UK Ltd      | E:
       Maximising throughput & performance

-----Original Message-----
Gudmundur Josepsson
Sent: 16 September 2003 11:19
To: Multiple recipients of list ORACLE-L

There is no MSSQL utility that is directly equivalent to RMAN. You use Enterprise Manager or Query Analyzer to manage backups.

----- Original Message -----
To: Multiple recipients of list ORACLE-L Sent: Tuesday, September 16, 2003 9:39 AM

Hi good people-
 anyone out there know of the equivalent of oracle’s RMAN in MS SQL server environs.
I’m investigating the possibility of having my SQL server dump the backups direct to a third party tape library –VERITAS to be specific.

Your input on this thread will be highly appreciated.

CSW Simon.

Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (
Version: 6.0.515 / Virus Database: 313 - Release Date: 01/09/2003

Please see the official ORACLE-L FAQ:
Author: Mark Leith INET: Fat City Network Services -- 858-538-5051 San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: (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 Tue Sep 16 2003 - 06:04:24 CDT

Original text of this message