Hi all

I'm given .BAK files which are created by SQL Server during it's backup process. These BAK files are then restored using Enterprise Manager. The directories of the source machine differ from mine and I am not aware of the folder names until I create a new database and then attempt to restore it and check the options.

This indicates the folder names are in the .BAK file. Is there a utility that can alter the folder names in a .BAK file? Or is there some way I can tell enterprise manager to ignore the folder names and just put all files in a specified folder?

Thanks!