Veritas-bu

Re: [Veritas-bu] Slow backup for MSSQL DB server with man DBs?

2010-01-28 00:54:53
Subject: Re: [Veritas-bu] Slow backup for MSSQL DB server with man DBs?
From: "WEAVER, Simon \(external\)" <simon.weaver AT astrium.eads DOT net>
To: "David Stanaway" <david AT stanaway DOT net>, <veritas-bu AT mailman.eng.auburn DOT edu>
Date: Thu, 28 Jan 2010 05:54:33 -0000
DAvid
What NBU version you got?
I had 5.1 and had the same sort of issues.
Went to 6.5 and now as well as the Parent Job kicking in, all DB's run
as well at the same time. 

Simon 

-----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 David
Stanaway
Sent: Wednesday, January 27, 2010 3:58 AM
To: veritas-bu AT mailman.eng.auburn DOT edu
Subject: [Veritas-bu] Slow backup for MSSQL DB server with man DBs?

We have a MSSQL server with ~200 very small databases. This takes a very
long time to backup as each DB spawns a new job that needs to get qued
then start up the media session etc.

We used to back it up with Legato pretty quickly, but now the lag is
quite noticeable and it eats into our maintenance window.

Is there anything we can do to decrease the lost time between backup
jobs for a SQL policy with the $ALLDATABASES target with this many
databases?
_______________________________________________
Veritas-bu maillist  -  Veritas-bu AT mailman.eng.auburn DOT edu
http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu

This email (including any attachments) may contain confidential
and/or privileged information or information otherwise protected
from disclosure. If you are not the intended recipient, please
notify the sender immediately, do not copy this message or any
attachments and do not use it for any purpose or disclose its
content to any person, but delete this message and any attachments
from your system. Astrium disclaims any and all liability if this
email transmission was virus corrupted, altered or falsified.
-o-
Astrium Limited, Registered in England and Wales No. 2449259
Registered Office:
Gunnels Wood Road, Stevenage, Hertfordshire, SG1 2AS, England
_______________________________________________
Veritas-bu maillist  -  Veritas-bu AT mailman.eng.auburn DOT edu
http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu