Rman equivalent for MS-SQL server

2003-09-16 Thread waibals 








Hi good people-

Does anyone out there know of the equivalent of oracles
RMAN in MS SQL server environs.

Im 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.

Re: Rman equivalent for MS-SQL server

2003-09-16 Thread Gudmundur Josepsson 



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

Gudmundur

  - Original Message - 
  From: 
  [EMAIL PROTECTED] 
  To: Multiple recipients of list ORACLE-L 
  
  Sent: Tuesday, September 16, 2003 9:39 
  AM
  Subject: Rman equivalent for MS-SQL 
  server
  
  
  Hi good 
  people-
  Does 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.

RE: Rman equivalent for MS-SQL server

2003-09-16 Thread Mark Leith 
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.

http://www.chriskempster.com/

HTH

Mark

===
 Mark Leith | T: +44 (0)1905 330 281
 Sales  Marketing  | F: +44 (0)870 127 5283
 Cool Tools UK Ltd  | E: [EMAIL PROTECTED]
===
   http://www.cool-tools.co.uk
   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.

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


Hi good people-
Does 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 (http://www.grisoft.com).
Version: 6.0.515 / Virus Database: 313 - Release Date: 01/09/2003

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Mark Leith
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (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).

RE: Rman equivalent for MS-SQL server

2003-09-16 Thread Farnsworth, Dave 



This 
beast does not exist. You can use the Database Maintenance Plans in EM to 
manage your backups. I have found these to be flaky and prefer writing my 
own custom backup plans in scripts and schedule these as jobs. >From my 
experience on SQL Server I recommend doing a native SQL Server backup to disk, 
then have the third party backup software pickup those files to 
tape.
Just 
my $.02

Dave

  -Original Message-From: [EMAIL PROTECTED] 
  [mailto:[EMAIL PROTECTED]Sent: Tuesday, September 16, 2003 4:39 
  AMTo: Multiple recipients of list ORACLE-LSubject: Rman 
  equivalent for MS-SQL server
  
  Hi good 
  people-
  Does anyone out there know of the 
  equivalent of oracles RMAN in MS SQL server environs.
  Im 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.