Re: MS-SQL TDP update date
2003-07-17 13:07:29
Hi Del,
>>> 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:
Hi Del,
We back them up using a scheduled script. An example
tsm: BACKUP>q file MSSQLAFS f=d
Node Name: MSSQLAFS
Filespace Name: AFSDBMS.master
Platform: WinNT
Filespace Type: API:NTSQL
Capacity (MB): 0.0
Pct Util: 0.0
Last Backup Start Date/Time: 07/08/02 21:11:25
Days Since Last Backup Started: 374
Last Backup Completion Date/Time: 07/08/02 21:11:31
Days Since Last Backup Completed: 374
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?
|
|
|