EdVassie (4/8/2013)
However, having seen the suggestion to use log shipping I think that probably needs the lowest skill level to get it working. As already mentioned it will need some down-time at point of cutover, but you should be looking at less than 5 minutes.I would only use replication for this if I wanted to make things really complicated...
Agreed on all counts. Mirroring could be used and I would also favor it over Replication. Ross.M mentioned they had some Log Shipping experience so it seemed like the path of least resistance to deliver a working solution. I think LS and Mirroring would both result in an almost equivalent end-user experience provided things were scripted ahead of time like I mentioned.
@Ross.M One other item worth mentioning about the LS solution: when you're happy with running on the version of the database with its files on the SAN you'll want to remember to drop the LS configuration from the instance to clear out the jobs and metadata entries from the system tables.
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato