Easy restore question on SQL 2005

Posted on 2008-11-06
Last Modified: 2012-05-05
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!
Question by:hillandale
    LVL 32

    Assisted Solution

    by:Daniel Wilson
    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.

    Accepted Solution

    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: (link given to me courtesy of Edgewood Solutions).
    LVL 32

    Expert Comment

    by:Daniel Wilson
    Cool ... thanks for the link!

    Featured Post

    Highfive Gives IT Their Time Back

    Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

    Join & Write a Comment

    Suggested Solutions

    There are some very powerful Data Management Views (DMV's) introduced with SQL 2005. The two in particular that we are going to discuss are sys.dm_db_index_usage_stats and sys.dm_db_index_operational_stats.   Recently, I was involved in a discu…
    In this article I will describe the Backup & Restore method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
    Hi everyone! This is Experts Exchange customer support.  This quick video will show you how to change your primary email address.  If you have any questions, then please Write a Comment below!
    In this seventh video of the Xpdf series, we discuss and demonstrate the PDFfonts utility, which lists all the fonts used in a PDF file. It does this via a command line interface, making it suitable for use in programs, scripts, batch files — any pl…

    734 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    19 Experts available now in Live!

    Get 1:1 Help Now