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 ?
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 ?
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
before that make sure you have the sql authentication enabled on that database and you have the password for that
all the best
ASKER
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.
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) accountsHow to do that ?
ASKER CERTIFIED SOLUTION
![Avatar of Guy Hengel [angelIII / a3]](https://filedb.experts-exchange.com/files/public/2013/11/25/ddbe0ea6-aa6e-4279-b781-57b735dd3ea0.jpeg){kind=small}
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
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 ?
only the domain accounts, The sql based logins will not be touched.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
@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 ?
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 ?
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks !
after the join, the only "issues" you may have is to recreate and regrant the logins based on windows (domain) accounts, if any