topic Re: Restore SQL Databases in Operating System - HP-UX

Restore SQL Databases

Roberto Alonso — Fri, 27 Feb 2004 16:13:44 GMT

If I need to restore a DB to another location (diferent from the source) and also I need to change the location files, which are the options to set in the restore procedure of DP 5.1

Re: Restore SQL Databases

Steven E. Protter — Fri, 27 Feb 2004 17:06:14 GMT

If you do the install in the X Windows GUI, there is a checkbox that lets you decide whether or not to restore to the original location.

As I recall it is checked and you need to uncheck it and specify a restore location.

SEP

Re: Restore SQL Databases

Roberto Alonso — Mon, 01 Mar 2004 07:58:47 GMT

Ok, but what I need is to change the location of the files that support the database. I bakcup from one server with n files groups and I need to restore to another server in diferent locations. I supposed that if I do right-click on the object to restore there I can do some changes to it.

Where can I download the manual for this product?.
Thanks
Roberto

Re: Restore SQL Databases

Kurt Beyers. — Mon, 01 Mar 2004 11:34:25 GMT

Roberto,

First make sure that the online backup of SQL server on your target server is configured in DP as well.

The manuals can be downloaded from http://ovweb.external.hp.com/lpe/doc_serv/ (product: storage data protector). The Windows Integration guide discusses the online backup of SQL server. The Admin guide might be usefull as well.

best regards,

Kurt

Re: Restore SQL Databases

Roberto Alonso — Mon, 01 Mar 2004 12:16:51 GMT

Ok thanks, I could resolve setting the properties for the object to restore. I have to redirect all the files to the new location.
Thanks
Roberto