Larry,

You can't tell the version from the TSM Server side.
The DP for SQL CLI or GUI will show the version.

A filespace name with the database name in it
indicates a DP for SQL version 1 client.
   For example: CLARKL.master

Filespace names with "meta" and "data" in them
indicate a DP for SQL version 2 or Version 5 client.
   For example: HOOBLER\meta\0000
                HOOBLER\data\0001

Thanks,

Del

----------------------------------------------------

Del Hoobler
IBM Corporation
hoobler AT us.ibm DOT com



                      Lawrence Clark
                      <[email protected]        To:       ADSM-L AT 
VM.MARIST DOT EDU
                      TATE.NY.US>                   cc:
                      Sent by: "ADSM: Dist          Subject:  Re: MS-SQL TDP 
update date
                      Stor Manager"
                      <ADSM-L AT VM.MARIST DOT EDU>


                      07/17/2003 01:26 PM
                      Please respond to
                      "ADSM: Dist Stor
                      Manager"






Del,
How can you tell if those were a previous version. I did a test install
on my pc....Does this indicate a 5.1.5 TDP?
 Node Name: LCMSSQL
                  Filespace Name: CLARKL.master
                        Platform: TDP MSSQL
                  Filespace Type: API:NTSQL
                   Capacity (MB): 0.0
                        Pct Util: 0.0
     Last Backup Start Date/Time: 06/19/03   14:12:09
  Days Since Last Backup Started: 28
Last Backup Completion Date/Time: 06/19/03   14:12:19
Days Since Last Backup Completed: 28



>>> hoobler AT US.IBM DOT COM 07/17/03 12:09PM >>>
Larry,

If you are referring to the "Last Backup Start Date/Time:"
on the filespace, it is updated after a successful backup.
Here is an example from my QUERY FILESPACE:

tsm: TSMSERVER1>q file HOOBLER_SQL f=d

                                      Node Name: HOOBLER_SQL
                                 Filespace Name: HOOBLER\meta\0000
                     Hexadecimal Filespace Name:
                                           FSID: 18
                                       Platform: TDP MSSQL Win32
                                 Filespace Type: API:SqlData
                          Is Filespace Unicode?: No
                                  Capacity (MB): 0.0
                                       Pct Util: 0.0
                    Last Backup Start Date/Time: 07/17/2003 09:50:03
                 Days Since Last Backup Started: <1
               Last Backup Completion Date/Time: 07/17/2003 09:50:04
               Days Since Last Backup Completed: <1
Last Full NAS Image Backup Completion Date/Time:
Days Since Last Full NAS Image Backup Completed:

                                      Node Name: HOOBLER_SQL
                                 Filespace Name: HOOBLER\data\0001
                     Hexadecimal Filespace Name:
                                           FSID: 19
                                       Platform: TDP MSSQL Win32
                                 Filespace Type: API:SqlData
                          Is Filespace Unicode?: No
                                  Capacity (MB): 0.0
                                       Pct Util: 0.0
                    Last Backup Start Date/Time: 07/17/2003 09:50:03
                 Days Since Last Backup Started: <1
               Last Backup Completion Date/Time: 07/17/2003 09:50:04
               Days Since Last Backup Completed: <1
Last Full NAS Image Backup Completion Date/Time:
Days Since Last Full NAS Image Backup Completed:

Thanks,

Del

----------------------------------------------------
> In earlier versions of the TDP for MS-SQL the last backup date was
only
> updated when the backup was executed via the GUI, not through a
script
> running the backup command.
>
> Has that changed with 5.1.5, so it there someway to refresh the
backup
> date through a script I'm not away of?