SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2008 Forums
 SQL Server Administration (2008)
 Migration
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

guaro5555
Starting Member

15 Posts

Posted - 04/08/2013 :  14:18:55  Show Profile  Reply with Quote
Hi gurus

I have a sql 2008 instance database on a different domain company A, I would like to bring that company A database to our cluster on a different domain on company B, would someone one please let me know the steps for this to be accomplished.

Thanks gurus.

tkizer
Almighty SQL Goddess

USA
36845 Posts

Posted - 04/08/2013 :  20:10:28  Show Profile  Visit tkizer's Homepage  Reply with Quote
Just a normal backup/restore and then fix up the userids. Are the users using Windows authentication?

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page

guaro5555
Starting Member

15 Posts

Posted - 04/08/2013 :  21:41:08  Show Profile  Reply with Quote
Tara

Thanks a bunch for jumping in, I just took on the sql server legacy, if I want to bring this new database to our cluster don't I have to create the instance first?
if that is the case do you have a doc that I can follow to add this new database as a new instance on our sql cluster.

Thanks a bunch tara
Go to Top of Page

guaro5555
Starting Member

15 Posts

Posted - 04/08/2013 :  22:04:44  Show Profile  Reply with Quote
Tara, also there is already a cluster with two nodes and multiple instances of sql server, do I still need a networkname for this new instance on my already setup cluster, can you help me with this networkname dilema..

again thanks a bunch
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.06 seconds. Powered By: Snitz Forums 2000