Solved

SQL Server implications of leaving and rejoining a domain

Posted on 2011-03-03
6
731 Views
Last Modified: 2012-05-11
Hi Experts. I have a users mailbox/an email that I need to restore.Unfortunately the email is on a tape that was backed up with CA Arcserve 11.5 SP3 before an upgrade. The issue is we are now running Exchange 2010 and Server 2008 R2 domain. I dont think it'd be possible to install Exchange 2003 in the same domain(correct me if Im wrong) and do the restore neither could I restore to pst or msg files(correct me if Im wrong).I created a fresh Exchange 2003 server (SBS 2003) and installed the Exchange Agent outside the domain on a seperate network. I then took the ArcServe server and plugged it into the other domain. When I try and run the restore Arcserve is not seeing the Exchange server as a likely destination however it can see files shares and SQL etc. I suspect it could be a domain issue since when I installed the Backup Manager on another machine in the new network it can see the Exchange destination. The problem is the server with ArcServe also holds the SQL Server databases for the organisation. What are the implications of leaving domain A, joining domain B and trying the restore then when I finish rejoin domain A. Would that break my SQL or cause any other issues? - And yes, according to the CEO the email is that important :)
0
Comment
Question by:takwirirar
  • 3
  • 2
6 Comments
 
LVL 15

Accepted Solution

by:
Aaron Shilo earned 500 total points
Comment Utility
your main issue will be with your server logins
they will be broken.
0
 
LVL 1

Author Comment

by:takwirirar
Comment Utility
Thanks for quick response. You mean server logins for SQL? Do you have any suggestions on how I can get around this?
0
 
LVL 15

Expert Comment

by:Aaron Shilo
Comment Utility
read this guide for the aftermath of switching domains. :
http://support.microsoft.com/kb/283811
0
PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

 
LVL 18

Expert Comment

by:lludden
Comment Utility
If you can restore the base EDB files, you can use a product like Ontrack PowerTools to restore the messages
http://www.ontrackpowercontrols.com/

I have used this product several times to restore into either PST or current mailboxes, the entire contents of an exchange database for which I not longer had an exchange server or matching domain.

It can be expensive, but it works.
0
 
LVL 1

Author Comment

by:takwirirar
Comment Utility
This is the issue, ArcServe will not allow me to even restore the EDB files
0
 
LVL 1

Author Closing Comment

by:takwirirar
Comment Utility
Answers the question. The problem was with the RPC service. Restarted it and managed to restore the items.
0

Featured Post

Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

Join & Write a Comment

JSON is being used more and more, besides XML, and you surely wanted to parse the data out into SQL instead of doing it in some Javascript. The below function in SQL Server can do the job for you, returning a quick table with the parsed data.
Slowly Changing Dimension Transformation component in data task flow is very useful for us to manage and control how data changes in SSIS.
This tutorial will walk an individual through setting the global and backup job media overwrite and protection periods in Backup Exec 2012. Log onto the Backup Exec Central Administration Server. Examine the services. If all or most of them are stop…
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.

743 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

17 Experts available now in Live!

Get 1:1 Help Now