Friday, February 24, 2012

Is DB Mirroring supported in SQL 2005?

I just read the follwing statement in the help file.
Important:
Microsoft support policies do not apply to the database mirroring feature in
SQL Server 2005. Database mirroring is currently disabled by default, but may
be enabled for evaluation purposes only by using trace flag 1400 as a startup
parameter. (For more information about trace flags, see Trace Flags
(Transact-SQL).) Database mirroring should not be used in production
environments, and Microsoft support services will not support databases or
applications that use database mirroring. Database mirroring documentation is
included in SQL Server 2005 for evaluation purposes only, and the
Documentation Policy for SQL Server 2005 Support and Upgrade does not apply
to the database mirroring documentation.
I know that mirroring wasn't available in the original release, but was
available after installing sp1, which I have installed. Is it supported and
safe to use?
Another question I have is, If a snapshot is created off the mirror, which
is on a seperate server from production, and mirroring with high protection
is being used, is it possible for a long running report to cause performance
issues on the prod server? Or could the report prevent the mirror from
getting updated?
Thanks
--
MG>I just read the follwing statement in the help file.
When you upgraded your server to SP1, did you also install the updated Books
Online documentation? The help files are updated frequently. The most
recent official release is July 2006:
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
But if you want the most recent copy (including some information on SP2) you
can get it here:
http://www.microsoft.com/downloads/details.aspx?familyid=19db0b42-a5b2-456f-9c5c-f295cdd58d7a
A|||Thanks
I only installed sp1, but not the updated documentation.
--
MG
"Aaron Bertrand [SQL Server MVP]" wrote:
> >I just read the follwing statement in the help file.
> When you upgraded your server to SP1, did you also install the updated Books
> Online documentation? The help files are updated frequently. The most
> recent official release is July 2006:
> http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
> But if you want the most recent copy (including some information on SP2) you
> can get it here:
> http://www.microsoft.com/downloads/details.aspx?familyid=19db0b42-a5b2-456f-9c5c-f295cdd58d7a
> A
>
>

No comments:

Post a Comment