What I have found since my previous email is this.

If I run my SQLFULL.CMD from the Client....The information is updated...But
if the server schedule calls up the command this information is not updated.

Any idea?

Mehdi Amini
LAN/WAN Engineer
ValueOptions
12369 Sunrise Valley Drive
Suite C
Reston, VA 20191
Phone: 703-390-6855
Fax: 703-xxx-xxxx


-----Original Message-----
From: Del Hoobler [mailto:hoobler@;US.IBM.COM]
Sent: Wednesday, November 13, 2002 10:38 AM
To: [EMAIL PROTECTED]
Subject: Re: SQL 2.2.1


Mehdi,

I suggest calling support since it should be working.

It works when I back up my SQL 2000 server using
TDP for SQL 2.2.1 to a TSDM 5.1.0 TSM server.

BEFORE
======

                                      Node Name: HOOBIE_SQL
                                 Filespace Name: HOOBIE\meta\0000
                     Hexadecimal Filespace Name:
                                           FSID: 55
                                       Platform: TDP MSSQLV2 NT
                                 Filespace Type: API:SqlData
                          Is Filespace Unicode?: No
                                  Capacity (MB): 0.0
                                       Pct Util: 0.0
                    Last Backup Start Date/Time: 11/04/2002 16:17:53
                 Days Since Last Backup Started: 9
               Last Backup Completion Date/Time: 11/04/2002 16:18:50
               Days Since Last Backup Completed: 9
Last Full NAS Image Backup Completion Date/Time:
Days Since Last Full NAS Image Backup Completed:

                                      Node Name: HOOBIE_SQL
                                 Filespace Name: HOOBIE\data\0001
                     Hexadecimal Filespace Name:
                                           FSID: 56
                                       Platform: TDP MSSQLV2 NT
                                 Filespace Type: API:SqlData
                          Is Filespace Unicode?: No
                                  Capacity (MB): 0.0
                                       Pct Util: 0.0
                    Last Backup Start Date/Time: 11/04/2002 16:17:53
                 Days Since Last Backup Started: 9
               Last Backup Completion Date/Time: 11/04/2002 16:18:50
               Days Since Last Backup Completed: 9
Last Full NAS Image Backup Completion Date/Time:
Days Since Last Full NAS Image Backup Completed:


AFTER
=====

                                      Node Name: HOOBIE_SQL
                                 Filespace Name: HOOBIE\meta\0000
                     Hexadecimal Filespace Name:
                                           FSID: 55
                                       Platform: TDP MSSQLV2 NT
                                 Filespace Type: API:SqlData
                          Is Filespace Unicode?: No
                                  Capacity (MB): 0.0
                                       Pct Util: 0.0
                    Last Backup Start Date/Time: 11/13/2002 10:34:32
                 Days Since Last Backup Started: <1
               Last Backup Completion Date/Time: 11/13/2002 10:35:29
               Days Since Last Backup Completed: <1
Last Full NAS Image Backup Completion Date/Time:
Days Since Last Full NAS Image Backup Completed:

                                      Node Name: HOOBIE_SQL
                                 Filespace Name: HOOBIE\data\0001
                     Hexadecimal Filespace Name:
                                           FSID: 56
                                       Platform: TDP MSSQLV2 NT
                                 Filespace Type: API:SqlData
                          Is Filespace Unicode?: No
                                  Capacity (MB): 0.0
                                       Pct Util: 0.0
                    Last Backup Start Date/Time: 11/13/2002 10:34:32
                 Days Since Last Backup Started: <1
               Last Backup Completion Date/Time: 11/13/2002 10:35:29
               Days Since Last Backup Completed: <1
Last Full NAS Image Backup Completion Date/Time:
Days Since Last Full NAS Image Backup Completed:


Thanks,

Del

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

Del Hoobler
IBM Corporation
[EMAIL PROTECTED]

- Never cut what can be untied.
- Commit yourself to constant improvement.

=========================================================

> It does not update
>    Last Backup Start Date/Time
>    Last Backup Completion Date/Time


**********************************************************************
This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they
are addressed. If you have received this email in error please notify
the sender by email, delete and destroy this message and its
attachments.


**********************************************************************

Reply via email to