I am reinstalling Windows on a developer workstation, that runs SQL Server 2008R2 and contains a lot of SQL Server databases (~50).
After the reinstall, I want the SQL Server up and running with the same databases as easy as possible. It is just a workstation, so downtime is not an issue.
What is the easiest way to accomplish this?
Is it to attach the new SQL Server to the datafiles one at a time, or is there an easier way?
I am looking for the EASIEST way to do this with a lot of databases. Doing it one at a time, whether with backup/restore or attach/detach is not what I am looking for.
And of course I have backups.