database mirroring

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 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?
>
>|||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.sql

Database Mail and Sent Items folder

We are using SQL2005 Database Mail and sending emails using our Exchange
Server as the smtp server. There is an account set up in exchange that
Database Mail uses and it works great.
However, is there a way to have all emails that that account sends put into
the "Sent Items" folder for that account?
Any assistance would be greatly appreciated.
Sincerely,
Glen WolinskyHello Glen,
You may want to bcc to this account and configure rule for the account when
receing mail from itself, it routed it to sent item folder.
Or, you may want to use SQL mail which uses MAPI so that Exchange will save
sent items automatically.
Since the issue is related to Exchange, you may also ask in Exchange
newsgroup so that you may get more qualified answer.
Thanks & Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================
This posting is provided "AS IS" with no warranties, and confers no rights.

Database Mail and Sent Items folder

We are using SQL2005 Database Mail and sending emails using our Exchange
Server as the smtp server. There is an account set up in exchange that
Database Mail uses and it works great.
However, is there a way to have all emails that that account sends put into
the "Sent Items" folder for that account?
Any assistance would be greatly appreciated.
Sincerely,
Glen WolinskyHello Glen,
You may want to bcc to this account and configure rule for the account when
receing mail from itself, it routed it to sent item folder.
Or, you may want to use SQL mail which uses MAPI so that Exchange will save
sent items automatically.
Since the issue is related to Exchange, you may also ask in Exchange
newsgroup so that you may get more qualified answer.
Thanks & Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
========================================
=============
This posting is provided "AS IS" with no warranties, and confers no rights.