I have 5 production servers that have to be upgraded tomorrow morning out of hours. I would like to get it done quick so can you guide me on any problems or other experience that might help ?
I'm assuming I should just backup and then run the R2 setup program as opposed to backing up, removing sql, installing r2, restoring dbs - does that sound like a better approach ?
Each DB has between 5 and 20 customer databases in it. I can script all the backups etc no problem.
I would like to know if you've experienced any issues doing this or anything else I should prepare for.