Veritas-bu

Re: [Veritas-bu] Are my SQL DBA's lying to me?

2007-10-12 20:02:53
Subject: Re: [Veritas-bu] Are my SQL DBA's lying to me?
From: "Curtis Preston" <cpreston AT glasshouse DOT com>
To: "Johnson, Eric" <Eric.Johnson AT mtsallstream DOT com>, <bobbyrjw AT comcast DOT net>, <veritas-bu AT mailman.eng.auburn DOT edu>
Date: Fri, 12 Oct 2007 19:49:44 -0400

Right, but he said every dataFILE has to be its own backup job.  That’s the part that doesn’t seem right.

 

Or is it that when he backs up the tran log, each log is its own file?

 

---

W. Curtis Preston

Backup Blog @ www.backupcentral.com

VP Data Protection, GlassHouse Technologies


From: veritas-bu-bounces AT mailman.eng.auburn DOT edu [mailto:veritas-bu-bounces AT mailman.eng.auburn DOT edu] On Behalf Of Johnson, Eric
Sent: Friday, October 12, 2007 2:40 PM
To: bobbyrjw AT comcast DOT net; veritas-bu AT mailman.eng.auburn DOT edu
Subject: Re: [Veritas-bu] Are my SQL DBA's lying to me?

 

Hi Bobby,

 

I believe they are telling you the truth. I’ve set up the MS SQL agent as well, and every database comes through as it’s own backup job. I’m not aware of any way to alter this behaviour, but I haven’t really looked into it.

 

Eric

 


From: Bobby Williams [mailto:bobbyrjw AT comcast DOT net]
Sent: Friday, October 12, 2007 1:41 PM
To: veritas-bu AT mailman.eng.auburn DOT edu
Subject: [Veritas-bu] Are my SQL DBA's lying to me?

 

NetBackup 5.0MP6 using MS SQL agent.

DBA's are saying that each database file in the DB instance has to come to the master/media server as a separate backup job.

I get hundreds of little bitty backups every time the logs need backed up.

Is this how other folks see the SQL agent implemented?

 

Bobby Williams
2205 Peterson Drive
Chattanooga, Tennessee  37421

423-296-8200

_______________________________________________
Veritas-bu maillist  -  Veritas-bu AT mailman.eng.auburn DOT edu
http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu