Backup target is disk.
------Original Message------
From: Marianne Van Den Berg
To: David Stanaway
Cc: VERITAS-BU AT MAILMAN.ENG.AUBURN DOT EDU
Subject: RE: [Veritas-bu] Slow backup for MSSQL DB server with man DBs?
Sent: Jan 29, 2010 8:02 AM

Hi David

You can increase the Media Unmount Delay.

Extract from TN http://seer.entsupport.symantec.com/docs/316341.htm:

To specify a Media unmount delay property indicates that the unloading
of media is delayed after the requested operation is complete. Media
unmount delay applies only to user operations, to include backups and
restores of database agent clients, such as those running NetBackup for
Oracle. The delay reduces unnecessary media unmounts and the positioning
of media in cases where the media is requested again a short time later.

The delay can range from 0 seconds to 1800 seconds. The default is 180
seconds. If you specify 0, the media unmount occurs immediately upon
completion of the requested operation. Values greater than 1800 are set
to 1800.



Also have a look at GROUPSIZE variable in script - The number of
databases that will be snapped as a single SQL Server backup image.


Regards

M.


-----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: 27 January 2010 05: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


Sent on the Sprint® Now Network from my BlackBerry®
_______________________________________________
Veritas-bu maillist  -  Veritas-bu AT mailman.eng.auburn DOT edu
http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu