Mike Yearwood
Toronto, Ontario, Canada
Well, there's more than 50 tables and they are differ between installations. So when I get one .BAK, I have to create the directories and change all the physical filenames. If I could just tell SEM to simply put all files in one directory and then restore, it would be much easier.
>>I'm trying to avoid the pain of telling SEM what physical file to use for each logical file ;)
>
>Any particular reason?
>
>-Mike
>
>>Hi Mike
>>
>>I'm trying to avoid the pain of telling SEM what physical file to use for each logical file ;)
>>
>>>When using the SEM to do the restore, on the second tab you can specify the location to write the data files. This equates to using the RESTORE's MOVE TO option.
>>>
>>>-Mike
>>>
>>>>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!
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only