ADSM-L

Restoring SQL Database Question

2004-08-16 12:21:48
Subject: Restoring SQL Database Question
From: Jeff White <jeff.white AT CIS.CO DOT UK>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Mon, 16 Aug 2004 17:25:36 +0000
Hi,

TSM Server 5.1.5.2
TDP/SQL 2.2.1
TSM Client 5.1.5.0

What is the full command syntax, that i would enter from the SQL/TDP
command line client, to recover a database, but not the latest database.
The user's guide shows the command syntax for recovering the latest, but i
have a DB Administrator who has asked that i recover the backup PRIOR to
the latest. This would be fine via the GUI, but he asked if it was possible
to do this on a regular basis, overnight, so that it is recovered for him
prior to starting work. I was going to put this into a batch file and run
it via a schedule.

Any suggestions would be appreciated.

Jeff White
jeff.white AT cis.co DOT uk




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

This e-mail may contain confidential information or be privileged. It is 
intended to be read and used only by the named recipient(s). If you are not the 
intended recipient(s) please notify us immediately so that we can make 
arrangements for its return: you should not disclose the contents of this 
e-mail to any other person, or take any copies. Unless stated otherwise by an 
authorised individual, nothing contained in this e-mail is intended to create 
binding legal obligations between us and opinions expressed are those of the 
individual author.

The CIS marketing group, which is regulated for Investment Business by the 
Financial Services Authority, includes:
Co-operative Insurance Society Limited Registered in England number 3615R - for 
life assurance and pensions
CIS Unit Managers Limited Registered in England and Wales number 2369965  - for 
unit trusts and PEPs
CIS Policyholder Services Limited Registered in England and Wales number 
3390839 - for ISAs and investment products bearing the CIS name
Registered offices: Miller Street, Manchester M60 0AL   Telephone  
0161-832-8686   Internet  http://www.cis.co.uk   E-mail cis AT cis.co DOT uk

CIS Deposit and Instant Access Savings Accounts are held with The Co-operative 
Bank p.l.c., registered in England and Wales number 990937, P.O. Box 101, 1 
Balloon Street, Manchester M60 4EP, and administered by CIS Policyholder 
Services Limited as agent of the Bank.

CIS is a member of the General Insurance Standards Council

CIS & the CIS logo (R) Co-operative Insurance Society Limited

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

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