Hey guys

Thanks for taking the time to respond with so many different types of backup solutions for SQL 2005. I will go through these and any new ideas that are sent and let you guys know what we chose, thanks again.  

We have up on the oracle export scenario a couple of years ago.  Our databases became so large that we could no longer
make the backup window.  We have been using the Oracle Agent with RMAN, and with MSSQL as well.  We use Maestro, Veritas,
and cron to schedule our RMAN backups and things work quite well.

Hopefully those DBA's will see the light.


=============================
Carl Stehman
IT Distributed Services Team
Pepco Holdings, Inc.
202-331-6619
Pager 301-765-2703
ckstehman AT pepco DOT com

Ditto.  We bought the agents for both Oracle and MS SQL and they still won’t use them.  It’s caused lots of grief in the past – all issues that are addressed by the agents – but the DBAs don’t want to budge.  It’s their butts on the line if the databases have recovery issues though.
 
               …/Ed
 
--
Ed Wilts, Mounds View, MN, USA
mailto:ewilts AT ewilts DOT org
I GoodSearch for Bundles Of Love:  http://www.goodsearch.com/?charityid=821118
 
From: veritas-bu-bounces AT mailman.eng.auburn DOT edu [mailto:veritas-bu-bounces AT mailman.eng.auburn DOT edu] On Behalf Of Haskins, Steve
Sent: Tuesday, July 10, 2007 1:26 PM
To: Spearman, David; Jimenez, Daniel; veritas-bu AT mailman.eng.auburn DOT edu
Subject: Re: [Veritas-bu] MS SQL 2005 Backups
 
Same here along with trans logs.
 

From: veritas-bu-bounces AT mailman.eng.auburn DOT edu [mailto:veritas-bu-bounces AT mailman.eng.auburn DOT edu] On Behalf Of Spearman, David
Sent: Tuesday, July 10, 2007 10:50 AM
To: Jimenez, Daniel; veritas-bu AT mailman.eng.auburn DOT edu
Subject: Re: [Veritas-bu] MS SQL 2005 Backups
 
Daniel,
 
Our DBA's won't touch the Veritas solution for MS-SQL or Oracle. They are firm believers in exporting the database(s) to flat files and backing those up. Don't ask, I don't know why. Suffice to say they are the DBA's and we just do as we are told.
 
David Spearman
County of Henrico, Va.
-----Original Message-----
From: veritas-bu-bounces AT mailman.eng.auburn DOT edu [mailto:veritas-bu-bounces AT mailman.eng.auburn DOT edu] On Behalf Of Jimenez, Daniel
Sent: Tuesday, July 10, 2007 1:39 PM
To: veritas-bu AT mailman.eng.auburn DOT edu
Subject: [Veritas-bu] MS SQL 2005 Backups
Hey guys
 
We are going to start backing up MS SQL 2005 and I would like to know the best ways to backup this type of database? Can anyone through their experiences give me their solution and why they felt it was the best way to do this? I know there is the Veritas way and that may be the best way of doing these backups but I would like to hear some alternative ways that may be better than using the Veritas solution, thanks.
 
Daniel Jimenez
Backup and Recovery _______________________________________________
Veritas-bu maillist  -  Veritas-bu AT mailman.eng.auburn DOT edu
http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu



This Email message and any attachment may contain information that is proprietary, legally privileged, confidential and/or subject to copyright belonging to Pepco Holdings, Inc. or its affiliates ("PHI"). This Email is intended solely for the use of the person(s) to which it is addressed. If you are not an intended recipient, or the employee or agent responsible for delivery of this Email to the intended recipient(s), you are hereby notified that any dissemination, distribution or copying of this Email is strictly prohibited. If you have received this message in error, please immediately notify the sender and permanently delete this Email and any copies. PHI policies expressly prohibit employees from making defamatory or offensive statements and infringing any copyright or any other legal right by Email communication. PHI will not accept any liability in respect of such communications.