Indianrock (6/4/2009)
Another DR possibility is stopping the sql service on the log ship standby long enough to copy the data and ldf files elsewhere for attachment. there is a kluge that allows you to do this.Attaching a log shipped data file generates an error, for which there is a workaround. I tested it and it worked on a single mdf database.
1.Create a new database with the same name as the one you are trying to attach.
2.(optional) Detach the database, and then move the MDF and LDF files to the specific drives that you need.
3.(optional) Reattach the database from it's new location. You will have to update the paths to the LDF file when restoring.
4.Take the database Offline.
5.Copy your original MDF and LDF files and overwrite the newly created files.
6.Bring the database back Online.
A word of caution, don't base your DR around some half baked scheme that "seems to work", you could come unstuck when you least want it and could well end up typing your resume when a disaster occurs 😉
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉