Does anyone know if you can read the mirror database after installing sql
2005 sp1.
I did setup mirror config before sp1 came out, but at that time the mirror
db was not avilable to read, but I heard then in sp1 it was going to be
fixed, so you can read the mirror db.
Thank you.Check out this thread in this forum: SQL 2005 Architecture Question -
Active Secondary Database?|||Nope. You cannot read the mirror database. You can create a DB Snapshot of
the mirror database and read the snapshot, which has worked since the first
CTPs. For true reporting consider using replication.
--
Mark Wistrom [MSFT]
This posting is provided "AS IS" with no warranties, and confers no rights.
"john" <john@.discussions.microsoft.com> wrote in message
news:89921180-B433-40F0-AB00-13185B8C115C@.microsoft.com...
> Does anyone know if you can read the mirror database after installing sql
> 2005 sp1.
> I did setup mirror config before sp1 came out, but at that time the mirror
> db was not avilable to read, but I heard then in sp1 it was going to be
> fixed, so you can read the mirror db.
> Thank you.|||This is a multi-part message in MIME format.
--020800020103060408080900
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
This is a NNTP newsgroup. What "forum" are you talking about?
--
*mike hodgson*
http://sqlnerd.blogspot.com
sterillo@.hotmail.com wrote:
>Check out this thread in this forum: SQL 2005 Architecture Question -
>Active Secondary Database?
>
>
--020800020103060408080900
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
<tt>This is a NNTP newsgroup. What "forum" are you talking about?</tt><br>
<div class="moz-signature">
<title></title>
<meta http-equiv="Content-Type" content="text/html; ">
<p><span lang="en-au"><font face="Tahoma" size="2">--<br>
</font></span> <b><span lang="en-au"><font face="Tahoma" size="2">mike
hodgson</font></span></b><span lang="en-au"><br>
<font face="Tahoma" size="2"><a href="http://links.10026.com/?link=http://sqlnerd.blogspot.com</a></font></span>">http://sqlnerd.blogspot.com">http://sqlnerd.blogspot.com</a></font></span>
</p>
</div>
<br>
<br>
<a class="moz-txt-link-abbreviated" href="http://links.10026.com/?link=mailto:sterillo@.hotmail.com">sterillo@.hotmail.com</a> wrote:
<blockquote
cite="mid1146764469.171645.227080@.j33g2000cwa.googlegroups.com"
type="cite">
<pre wrap="">Check out this thread in this forum: SQL 2005 Architecture Question -
Active Secondary Database?
</pre>
</blockquote>
</body>
</html>
--020800020103060408080900--|||You cannot read from nor update a database involved in a mirroring session
while is acting as the 'mirror' role, but you can create a snapshot at any
moment and read from the snapshot. See this link:
http://msdn2.microsoft.com/en-us/library/ms175511.aspx
--
This posting is provided "AS IS" with no warranties, and confers no rights.
HTH,
~ Remus Rusanu
SQL Service Broker
http://msdn2.microsoft.com/en-us/library/ms166043(en-US,SQL.90).aspx
"john" <john@.discussions.microsoft.com> wrote in message
news:89921180-B433-40F0-AB00-13185B8C115C@.microsoft.com...
> Does anyone know if you can read the mirror database after installing sql
> 2005 sp1.
> I did setup mirror config before sp1 came out, but at that time the mirror
> db was not avilable to read, but I heard then in sp1 it was going to be
> fixed, so you can read the mirror db.
> Thank you.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment