Veritas-bu

[Veritas-bu] SQL Online Agent Backups - Using alot of tapes

2009-09-23 13:09:55
Subject: [Veritas-bu] SQL Online Agent Backups - Using alot of tapes
From: "WEAVER, Simon \(external\)" <simon.weaver AT astrium.eads DOT net>
To: <veritas-bu AT mailman.eng.auburn DOT edu>
Date: Wed, 23 Sep 2009 18:06:45 +0100

Hi All,
I am trying to figure out where I tell SQL Server clients to stream all its data to a small number of tapes.

For example I have a Storage Unit, set to Multiplex to 25 to one drive.

Within my SQL Server Policy, if I look at "Default-Application-Backup", Media Multiplex is set to 25.

The Policy holds approx 10 clients and each has ALOT of DB's on them.

Apart from what I am doing, is there anything else within the SQL Agent / GUI that I can look at to try to help?
Problem I have is when a 6 drive robot has 4 drives in use for SQL, then alot of jobs are queuing. I am going to look at changing the backup Window, but as I was here, thought I would pose the question to any fellow online SQL Bods.

Ta muchly.

Regards

Simon

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
<Prev in Thread] Current Thread [Next in Thread>
  • [Veritas-bu] SQL Online Agent Backups - Using alot of tapes, WEAVER, Simon (external) <=