I was able to restore the NorthWind db to a test database (on the same server) with no trouble and it did not affect the orginal Northwind db.  I used the TDP GUI...right clicked on the db and clicked on "relocate"(this might take some time to read the info from tape).  I also had to have the "Wait for tape mounts for file information" checked in order for it to give me the option of changing the file locations.  You also want to right click and use the "Restore into" option to rename the db.

J

Jeremy:

Thanks for your help, but still need to ask you some things

Is posible to TSM Restore system databases master, msdb, etc. ?

Is posible restrict the user of TSM Ser to just db_backupoperator role ?

Thanks in advance

By the way I'm from Santiago de Chile, where are you from ?

We use TSM and TDP (the Tivoli Data Protection) module that backs up SQL databases directly using the native backup command and virtual devices.  There was a problem with the old release of the client, it would only allow you to change the name of ONE of the database files on a restore (not very useful if you have a mdf and ldf).  However, the GUI would let you change them all, it is just tedious to do.

I am told that the newest TDP client has fixed the bug and the 'move' option is fullu functional.

One way I got around the old bug was to create an empty database with the new desired name, but with the old logical file names (but the new physical file names).  Then you could do a TDP restore with replace over it and it would honor the new physical file names.

Can you tell me wich versión of TDP do you use ?

IBM Tivoli Storage Manager for Databases - MS SQL 05.01.0500
Tivoli Storage Manager Client 05.01.0100

This Way can I check the versión of the product here.

Thanks

We walk in the dark places no others will enter
We stand on the bridge and no one may pass