retention on SQL 6.5 and SQL 2005

[nabildz]

Guys need some help please

we have 2 nodes one running SQL 6.5 and one SQL 2005 both using same policy/copy group

Policy Domain Name
SQL
Policy Set Name
SQL
Mgmt Class Name
SQL
Copy Group Name
STANDARD
Versions Data Exists
1
Versions Data Deleted
0
Retain Extra Versions
60
Retain Only Version
90
Copy Mode
MODIFIED
Copy Serialization
SHRSTATIC
Copy Frequency
0
Copy Destination
TAPEPOOL
Table of Contents (TOC) Destination
-
Last Update Date/Time
2005-07-15 08:14:25.000000
Last Update by (administrator)
ADMIN
Managing profile
-
​

the strange thing is SQL 2005 is only keeping 1 backup version but SQL 6.5 is keeping 30

how can that be??

Nabil

 

[rore]

Hi,
Are you sure that SQL 2005 is only keeping 1 backup version and SQL 6.5 is keeping 30? How did you confirm that?

Rudy

 

[nabildz]

I used the TDP gui, on the SQL 6.5 cleint is showing 30 versions and SQL 2005 just showing 1 version !!

 

[rore]

Well, your policy differs from what is recommended:

-Set VERSIONS DATA EXISTS and VERSIONS DATA DELETED to NO LIMIT.
-Set RETAIN EXTRA VERSIONS and RETAIN ONLY VERSION to the desired amount
of days you want you want to be able to go back and restore from.

You might want to align it.
What TDP and TSM server version are you using to backup SQL 6.5?

Rudy