Log Shipping Wizard Restores Log Files to Wrong Location
The problem I am having is that the wizard is restoring the files to the wrong locations.
For example, my files on the primary (Live) server are located in the following locations:
(Setup for OLTP so on separate spindles as best practise).
The files on the standby server live in the following location:
(All on a RAID 5 for OLAP type operations)
When restoring to the standby server I would assume this would restore to the same directories as the existing but it defaults to:
This therefore means it is dropping and re-creating the log file and not overwriting the existing one. Is there a setting to get round this or a way to generate a script for the whole log shipping process because by detaching and re-attaching the database after moving the log file puts it into recovered mode. I don't want to be restoring the databases twice with a move option when i come to doing our DR site which has a lot more complex disk subsystem. i.e the same as Live.
There is also the option to create a new database but when were talking 100's GB of data this takes sometime to write out the size of the files to disk which i don't want to do.