i could not find the answer to this on the net so i asked it here.
If i setup mirroring with standard config:
1 server with sql5000 server with 1 named instance (principal)
1 server with sql5000 server with 1 named instance (mirror)
1 server with sql5000 server with 1 named instance( witness)
Then i add a second named instance on the principal with some databases.
Must i setup an new config with witness and mirror to setp mirroring for
these databases?Or is it just simply selecting the databases in the new
instance and mirror them to the existing Mirror server and witness?
Many thx
--
I drank alot of beer and ended up in the police department database.
Drank more beer and learned SQL in the dark hours.
DELETE FROM offenders WHERE Title=''MrAA'' AND Year=2006;
I love SQL
Oeps....correction in my hurry i typed sql5000.... that will take while...
Offcourse i mean SQL 2005 and a normal server ...not clustered.
--
"Hate_orphaned_users" wrote:
> Hi all,
> i could not find the answer to this on the net so i asked it here.
> If i setup mirroring with standard config:
> 1 server with sql5000 server with 1 named instance (principal)
> 1 server with sql5000 server with 1 named instance (mirror)
> 1 server with sql5000 server with 1 named instance( witness)
> Then i add a second named instance on the principal with some databases.
> Must i setup an new config with witness and mirror to setp mirroring for
> these databases?Or is it just simply selecting the databases in the new
> instance and mirror them to the existing Mirror server and witness?
> Many thx
> --
> I drank alot of beer and ended up in the police department database.
> Drank more beer and learned SQL in the dark hours.
> DELETE FROM offenders WHERE Title=''MrAA'' AND Year=2006;
> I love SQL
>|||You use the same endpoints on the mirror and the witness. On the new instanc
e, you need to add the
endpoint. Then you need to do the BACKUP and ALTER DATABASE commands to enab
le mirroring.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Hate_orphaned_users" <Hateorphanedusers@.discussions.microsoft.com> wrote in
message
news:F4701A29-BF15-477C-A036-8E4FA2189F8D@.microsoft.com...[vbcol=seagreen]
> Oeps....correction in my hurry i typed sql5000....
that will take while...
> Offcourse i mean SQL 2005 and a normal server ...not clustered.
> --
>
>
> "Hate_orphaned_users" wrote:
>|||thx !
--
"Tibor Karaszi" wrote:
> You use the same endpoints on the mirror and the witness. On the new insta
nce, you need to add the
> endpoint. Then you need to do the BACKUP and ALTER DATABASE commands to en
able mirroring.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://sqlblog.com/blogs/tibor_karaszi
>
> "Hate_orphaned_users" <Hateorphanedusers@.discussions.microsoft.com> wrote
in message
> news:F4701A29-BF15-477C-A036-8E4FA2189F8D@.microsoft.com...
>
