Easy restore question on SQL 2005
Posted on 2008-11-06
We're running a primary production db server, and am installing secondary machines to test out a few backup/redundancy scenarios. So, now I'm restoring from our main server's full backup's to the new machines. One snag I've hit is that the new machines are a different "version" (with SP2 installed, I assume) than the original, so I can't restore the system databases. Am I correct in thinking that this is not necessarily a problem....? If I just restore our database, will I just lack user information (i.e. I'd have to re-create SQL login accounts), and maintenance job definitions (which would change anyway)?
Any other implications of this? Thanks!