Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 70
  • Last Modified:

SQL server restore and database integrity ?

People,

I'm currently migrating SQL server 2012 running on AD domain joined Windows server 2008 R2 to another physical box.

Assuming the image backup is able to capture both drives C and D drives, but disjoint the AD domain, is there anything that I need to know before starting the SQL server ?

The restored server will not be domain joined but the name will remain the same.

Does SQL server going to crash or complained when I rejoin the server again to AD under same name ?
0
Senior IT System Engineer
Asked:
Senior IT System Engineer
  • 4
  • 3
  • 3
3 Solutions
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
you only need to stop sql server before the image to make sure the sql file image will be consistent
after the join, the only "issues" you may have is to recreate and regrant the logins based on windows (domain) accounts, if any
2
 
Sajid Shaik MSr. System AdminCommented:
Guy Hengel is right,

before that make sure you have the sql authentication enabled on that database and you have the password for that

all the best
1
 
Senior IT System EngineerIT ProfessionalAuthor Commented:
Thanks for the clarification guys.

I will reset the SA account first.

The backup will be using Symantec System Recovery 2013 R2, so it is offline using bootable CD.

recreate and regrant the logins based on windows (domain) accounts
How to do that ?
0
Problems using Powershell and Active Directory?

Managing Active Directory does not always have to be complicated.  If you are spending more time trying instead of doing, then it's time to look at something else. For nearly 20 years, AD admins around the world have used one tool for day-to-day AD management: Hyena. Discover why

 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
here is what I referred to:
https://msdn.microsoft.com/en-us/library/ms175475.aspx

you may need to create new logins, and then map the users (from the databases) to the new logins
1
 
Senior IT System EngineerIT ProfessionalAuthor Commented:
you may need to create new logins, and then map the users (from the databases) to the new logins

Guy,

So do I just remap the AD domain account or the SQL account ?
0
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
only the domain accounts, The sql based logins will not be touched.
1
 
Sajid Shaik MSr. System AdminCommented:
i don't think this could happen in your case of "orphaned User" as SID of the user is same as existing ...because domain user is not changing i believe...

the best option is if it's in production environment first of all take DB backup safe side, test it on any of VM

then proceed to production.

all the best
1
 
Senior IT System EngineerIT ProfessionalAuthor Commented:
@Shaik M. Sajid,

Cool, that does make sense.

I suppose if I commission new server with new name & IP address from scratch, I can then just restore the SQL database backup ?
0
 
Sajid Shaik MSr. System AdminCommented:
yes that's true...

but same conditions applied the  u must know the SQL authentication id and password...
1
 
Senior IT System EngineerIT ProfessionalAuthor Commented:
Thanks !
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 4
  • 3
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now