[Last Call] Learn how to a build a cloud-first strategyRegister Now


Easy restore question on SQL 2005

Posted on 2008-11-06
Medium Priority
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
  • 2
LVL 32

Assisted Solution

by:Daniel Wilson
Daniel Wilson earned 200 total points
ID: 22897597
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

hillandale earned 0 total points
ID: 22898356
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).
LVL 32

Expert Comment

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

Featured Post

Important Lessons on Recovering from Petya

In their most recent webinar, Skyport Systems explores ways to isolate and protect critical databases to keep the core of your company safe from harm.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In SQL Server, when rows are selected from a table, does it retrieve data in the order in which it is inserted?  Many believe this is the case. Let us try to examine for ourselves with an example. To get started, use the following script, wh…
Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
Loops Section Overview
Despite its rising prevalence in the business world, "the cloud" is still misunderstood. Some companies still believe common misconceptions about lack of security in cloud solutions and many misuses of cloud storage options still occur every day. …

829 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