Yes. Data Protection for SQL supports this.

You will need to connect to the TSM Server
using the same TSM NODENAME (DSM.OPT file).

If you have different physical disk layouts,
you will have to use the /RELOCATE and /TO options.

Also, be aware, if the database is large,
just after the DP for SQL restore gets started,
SQL Server will spend a lot of time preformatting
the physical database files... it may look like the
restore is hung after only restoring a small amount of data...
... but it is not hung, it is preformatting. You will need
to make sure the COMMTIMEOUT value on the TSM Server is set
high in order for the SQL Server preformatting to complete
before the database data is restored.

Thanks,

Del

----------------------------------------------------

Del Hoobler
IBM Corporation
hoobler AT us.ibm DOT com

- Remember that the best job security is
doing a job well and doing it cheerfully.

==============================================================
> We are looking at different options of how to move all the SQL Server DBs
to
> the new box including the over 90GB ADW database on GBNDB07.  Do you know
if
> we backup ADW on the current GBNDB07, then perform a restore on the new
> GBNDB07 server??
>
> I'll be the first to admit that I just don't know enough about SQL to
> understand all of supporting SQL pieces and if they will allow this. We
> currently run full SQL backups on the box mentioned.
>
> Thoughts from some of the more SQL savvy folks on the list??