Yes, that is kinda what I guessed. I have the 4TB SQL backup still running from Saturday. It is only 50% done.
There has got to be a better way to handle SQL backups of LARGE databases. This is causing numerous headaches/problems with other backups by pre-allocating the space or if going to tape, locking the tape drives for the duration. Del, I know we discussed this and stripes (I have it configured for 3) for improving the speed, but this goes back to my question about breaking up the SQL backup into multiple chunks, especially with this new issue of it locking 4TB of disk space to contain the backup, until it finishes. I can't have 1-backup detrimentally effecting everyone else and at the speed it is running, it will take almost a week to finish. Suggestions? From: "Billaudeau, Pierre" <[email protected]> To: [email protected] Date: 09/13/2011 12:22 PM Subject: Re: [ADSM-L] Disk storage pool 100% utilized but NOT cached Sent by: "ADSM: Dist Stor Manager" <[email protected]> Hi Zoltan, Is it possible you had a very large (or several) backup running using the remaining 66% (over 4 tb) of your backup pool ? Current backups freezes backup data space on the disk pool so it is not eligible for migration. Pierre Billaudeau Analyste en stockage Livraison des Infrastructures Serveurs Société des Alcools du Québec 514-254-6000 x 6559 -----Message d'origine----- De : ADSM: Dist Stor Manager [mailto:[email protected]] De la part de Zoltan Forray/AC/VCU Envoyé : 13 septembre 2011 10:23 À : [email protected] Objet : [ADSM-L] Disk storage pool 100% utilized but NOT cached I think I know the answer to this question but figured it would be a good question to ask, This morning I was getting reports that backups were failing due to backups not being able to get space in the disk stgpool. When I did a "Q STG", this is what I get: 9:25:34 AM MOON : q stg Storage Device Estimated Pct Pct High Low Next Stora- Pool Name Class Name Capacity Util Migr Mig Mig ge Pool Pct Pct ----------- ---------- ---------- ----- ----- ---- --- ----------- ARCHIVEPOOL DISK 205 G 0.3 0.3 90 70 TS1130 BACKUPPOOL DISK 6,369 G 100.0 33.9 90 70 TS1130 Why would a disk storage pool be "100% Utilized" and only 34% migratable when I don't have Caching turned on? Zoltan Forray TSM Software & Hardware Administrator Virginia Commonwealth University UCC/Office of Technology Services [email protected] - 804-828-4807 Don't be a phishing victim - VCU and other reputable organizations will never use email to request that you reply with your password, social security number or confidential personal information. For more details visit http://infosecurity.vcu.edu/phishing.html ------------------ Information confidentielle : Le présent message, ainsi que tout fichier qui y est joint, est envoyé à l'intention exclusive de son ou de ses destinataires; il est de nature confidentielle et peut constituer une information privilégiée. Nous avertissons toute personne autre que le destinataire prévu que tout examen, réacheminement, impression, copie, distribution ou autre utilisation de ce message et de tout fichier qui y est joint est strictement interdit. Si vous n'êtes pas le destinataire prévu, veuillez en aviser immédiatement l'expéditeur par retour de courriel et supprimer ce message et tout document joint de votre système. Merci.
