TDP for MS SQL - Restore DB
2004-03-24 02:29:04
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>
|
- TDP for MS SQL - Restore DB,
Yiannakis Vakis <=
|
|
|