This is a multi-part message in MIME format.
--=_NextPart_000_0012_01C8A463.A358EA10
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
When setting up database mirroring with snapshots, do you require a = completely separate physical server (the mirror server with the = snapshot) or can this server be another SQL instance on the same box?
Thank-you,
Rubens
--=_NextPart_000_0012_01C8A463.A358EA10
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
&
When setting up database mirroring with = snapshots, do you require a completely separate physical server (the mirror server = with the snapshot) or can this server be another SQL instance on the same box?
Thank-you,
Rubens
--=_NextPart_000_0012_01C8A463.A358EA10--A database snapshot always reside in the same instance as the source database. If the snapshot is of
a mirrored database, then it need to be in the same instance as your mirrored database.
A mirror database is always in some *other* instance than the source database. The two instance
*can* be on the same machine, but that is only useful for demo-purposes (as it won't give your any
added fault tolerance).
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Rubens" <rubensrose@.hotmail.com> wrote in message news:%23KniQWIpIHA.3652@.TK2MSFTNGP03.phx.gbl...
When setting up database mirroring with snapshots, do you require a completely separate physical
server (the mirror server with the snapshot) or can this server be another SQL instance on the same
box?
Thank-you,
Rubens|||Okay makes sense, thank-you Tibor!
Rubens
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:eTiItfIpIHA.2208@.TK2MSFTNGP04.phx.gbl...
> A database snapshot always reside in the same instance as the source
> database. If the snapshot is of a mirrored database, then it need to be in
> the same instance as your mirrored database.
> A mirror database is always in some *other* instance than the source
> database. The two instance *can* be on the same machine, but that is only
> useful for demo-purposes (as it won't give your any added fault
> tolerance).
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://sqlblog.com/blogs/tibor_karaszi
>
> "Rubens" <rubensrose@.hotmail.com> wrote in message
> news:%23KniQWIpIHA.3652@.TK2MSFTNGP03.phx.gbl...
> When setting up database mirroring with snapshots, do you require a
> completely separate physical server (the mirror server with the snapshot)
> or can this server be another SQL instance on the same box?
> Thank-you,
> Rubens
>
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment