Results 1 to 5 of 5

Thread: moving db servers to new domain -- mirror question

  1. 12-03-2010, 09:11 AM #1
    ecka00
    ecka00 is offline Registered User
    Join Date
    May 2005
    Posts
    111

    moving db servers to new domain -- mirror question

    As part of the database properties for our existing DB mirrors the server names include the domain name (eg., servername.domain.xxx.xxx). When we move the servers to a new domain is there a way to regconfigure the existing mirrors to point to the new domain without starting over fresh?
    Reply With Quote Reply With Quote
  2. 12-03-2010, 09:29 AM #2
    ecka00
    ecka00 is offline Registered User
    Join Date
    May 2005
    Posts
    111

    sys.database_mirroring

    would it be possible to pause the mirrors and update whatever fields makeup the sys.database_mirroring view? if so, how would i find out what table/field are part of said view? i can't simply right click on it and choose script view as.... not an option.
    Reply With Quote Reply With Quote
  3. 12-03-2010, 07:14 PM #3
    rmiao
    rmiao is offline Registered User
    Join Date
    Sep 2002
    Posts
    5,938
    Not sure if let you do that, are domains trusted? Morroring may fail if not, need certificate in that case.
    Reply With Quote Reply With Quote
  4. 12-13-2010, 01:49 PM #4
    Lex87
    Lex87 is offline Registered User
    Join Date
    Nov 2010
    Posts
    2

    Quote Originally Posted by rmiao View Post
    Not sure if let you do that, are domains trusted? Morroring may fail if not, need certificate in that case.
    Mirroring the site does seem like an iffy prospect at best. Wouldn't the database end up broken in all likelihood?
    Reply With Quote Reply With Quote
  5. 12-14-2010, 08:28 AM #5
    rmiao
    rmiao is offline Registered User
    Join Date
    Sep 2002
    Posts
    5,938
    You can reset mirror.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules