Re: TDP for SQL Collocation

2004-03-02 Thread Del Hoobler
Zosi, If you plan to keep using a single stripe on your Data Protection for SQL backups, then you should be able to turn collocation off without ill effects to any particular Data Protection for SQL restore. You may affect the ability to restore two separate SQL Server backups simultaneously, but

Re: TDP for SQL Collocation

2004-03-01 Thread Zosimo Noriega
Dear Del, I'm using single stripe (STRIPes 1) for TDP for SQL. Regards, Zosi -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Del Hoobler Sent: Monday, March 01, 2004 4:42 PM To: [EMAIL PROTECTED] Subject: Re: TDP for SQL Collocation Zosi

Re: TDP for SQL Collocation

2004-03-01 Thread Del Hoobler
Zosimo A very important question you need to answer is: Are you are running Data Protection for SQL backups using multiple stripes? If you are, then you need to keep the data on separate tapes. That is because during restore, you will also be using striping and therefore those tapes will be moun

Re: TDP for SQL Collocation

2004-02-29 Thread TSM_User
Typically databases are backed up as a few large files. In addition the entire database is usually backed up together. Therefore the data will always be together no a tape when running a restore. As a result it is a very common practice not to collocate database data. Don't forget that if you h

TDP for SQL Collocation

2004-02-28 Thread Zosimo Noriega
Hi TSMers, Can I disable collocation option on TDP for SQL storage pool? I have 15 clients with small amount of TDP backups and stored into different tapes (10% average utilization) and we're running out of tapes on the library. What is the impact if I disable the collocation? Still I should eas