ADSM-L

Re: SQL 2.2.1

2002-11-13 13:22:10
Subject: Re: SQL 2.2.1
From: "Amini, Mehdi" <Mehdi.Amini AT VALUEOPTIONS DOT COM>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Wed, 13 Nov 2002 12:59:22 -0500
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 AT US.IBM DOT COM]
Sent: Wednesday, November 13, 2002 10:38 AM
To: ADSM-L AT VM.MARIST DOT EDU
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
hoobler AT us.ibm DOT com

- 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.


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

<Prev in Thread] Current Thread [Next in Thread>