How can I migrate my current NPM Microsoft SQL Server 2005 database (running on a Windows 2003 Server) to a Microsoft SQL 2008 R2 database without over writing the SQL 2008 database.
Have you seen the SolarWinds technical reference, "Moving Your Orion NPM Database"? It covers migrating from SQL 2005 to 2008.
HTH,