SQL server restore and database integrity ?
Posted on 2016-08-22
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 ?