Solved

SQL Server implications of leaving and rejoining a domain

Posted on 2011-03-03
6
734 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
ID: 35027875
your main issue will be with your server logins
they will be broken.
0
 
LVL 1

Author Comment

by:takwirirar
ID: 35027903
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
ID: 35028002
read this guide for the aftermath of switching domains. :
http://support.microsoft.com/kb/283811
0
What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

 
LVL 18

Expert Comment

by:lludden
ID: 35028063
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
ID: 35028151
This is the issue, ArcServe will not allow me to even restore the EDB files
0
 
LVL 1

Author Closing Comment

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

Featured Post

Best Practices: Disaster Recovery Testing

Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Get the latest status 8 32
performance query 4 24
SQL Query assistance 16 26
SQL invalid column name 5 13
International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
In this article we will learn how to backup a VMware farm using Nakivo Backup & Replication. In this tutorial we will install the software on a Windows 2012 R2 Server.
This tutorial will walk an individual through the process of configuring basic necessities in order to use the 2010 version of Data Protection Manager. These include storage, agents, and protection jobs. Launch Data Protection Manager from the deskt…
Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.

778 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