ADSM-L

TDP for MS SQL - Restore DB

2004-03-24 02:29:04
Subject: TDP for MS SQL - Restore DB
From: Yiannakis Vakis <yiannakis.vakis AT ITD.BANKOFCYPRUS DOT COM>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Wed, 24 Mar 2004 09:33:02 +0200
Hi,
I have the following schedules for a SQL dbase:
Saturdays - full backup of dbase
Weekdays - difffull backup of dbase

I wanted to restore the dbase on Wednesday to another server, so I used the
command line as follows:

tdpsqlc restore ChequeEnquiry full /relocate=ChequeEnquiryuiry_Data
/to=H:\tsmrestore\cheqenq.mdf /relocate=ChequeEnquiryuiry_Log
/to=H:\tsmrestore\cheqenq.lgf /fromsqlserver=IBCHQENQ
-TSMPassword=xxxxx

Have I restored the dbase as of last Saturday, or as of Tuesday ?
Thanks
Yiannakis

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