Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

mirroring database Expand / Collapse
Author
Message
Posted Monday, August 10, 2009 12:49 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Wednesday, October 12, 2011 4:07 AM
Points: 25, Visits: 82
Dear All,

can i do mirroing without have domain.
i have 3 database server in the same workgroup can i do the mirroring.


thanks alot.
Post #768094
Posted Tuesday, August 11, 2009 3:43 AM
SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Thursday, August 7, 2014 2:08 AM
Points: 4,432, Visits: 4,171
Yes you can use mirroring without a domain. But you might have to set it up using TSQL.
I remember that once you installed SP2, the wizard in SSMS won't accept a servername without domain suffix. Maybe this was fixed in SP3, but I can't check it right now.


Markus Bohse
Post #768453
Posted Tuesday, August 11, 2009 5:17 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Wednesday, October 12, 2011 4:07 AM
Points: 25, Visits: 82
i installed SQL 2005 SP3 but i can't do mirroring and i get this error.

TITLE: Database Properties
------------------------------

One or more of the server network addresses lacks a fully qualified domain name (FQDN). Specify the FQDN for each server, and click Start Mirroring again.

The syntax for a fully-qualified TCP address is:
TCP://.[.]:

------------------------------
BUTTONS:

OK
------------------------------
Post #768491
Posted Tuesday, August 11, 2009 6:58 AM
SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Thursday, August 7, 2014 2:08 AM
Points: 4,432, Visits: 4,171
That's exactly what I remembered.
But if you use TSQL scripts it should still work. This article should help you with it.
http://www.databasejournal.com/features/mssql/article.php/3832106/Database-Mirroring-Using-T-SQL.htm


Markus Bohse
Post #768548
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse