Easy restore question on SQL 2005

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!
hillandaleAsked:
Who is Participating?
 
hillandaleConnect With a Mentor Author Commented:
Thank you, Daniel. That does confirm what was missing.... The jobs (or those that I care about) can be scripted from the source system. The logins can be applied to the backup system per this: http://support.microsoft.com/kb/918992 (link given to me courtesy of Edgewood Solutions).
0
 
Daniel WilsonConnect With a Mentor Commented:
Yes, you'll just lack those items.

I'm not prepared to say that's not a problem ... you're going to have to set that up as part of your failover.
0
 
Daniel WilsonCommented:
Cool ... thanks for the link!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.