Thanks Gail, I think I have a better understanding now.

To summarize:

Transaction Isolation Level is different from Database Isolation Level setting.

When a database is at "Read Committed" Isolation Level:

Point: ...

GilaMonster (1/19/2012)

---

No. A client connection can accept the default (which is either READ_COMMITTED or READ_COMMITTED_SNAPSHOT depending on database settings), or it can request another isolation level explicitly (SET TRANSACTION ISOLATION...

Thank you for the quick response. I will try this on a test machine. May be adding a "backup device" could help me understand this better.

Thanks for the quick response.

So, if I understand your comment, these are true:

1: This is an explicit setting that comes from each client connection and Sql...

Yes, 70-432 is a prerequisite for MCITP (DBA).

[Extra Info: 70-433 is a per-requisite for MCITP (Developer) ]

Hope it helps,

_UB

SqlTimes

Thank you for the response. I have a couple of follow up questions.

Can I store compressed backup and un-compressed backup on the same LUN drive (disk drive attached to...

Any help is appreciated.

_U

Get in touch with your local Sql Server user groups.

I have used DB Mail for years now and I see the importance of DB mail. It is not to replace other notification services.

If you have MOM, then its...

Thank you for your input.

I am not sure I know how to do that. Also I do not have any control over SMTP Server since this is PROD. It was...

Service broker is enabled for msdb, the emails originate from either maintenance plans or jobs.

Happens every time I restart Sql. What is DB mail monitor? I did refresh DBmail from SSMS.

Edit: Emails go through when Sql Agent is restarted. So Sql Service restart is...

Yes, Sql Agent is also restarted along with Sql Server Service. This make me wonder, if the mails are processed when the Agent is restarted or the Sql Service. I...

Thanks Paul. I'll try this.

_Ub

Thanks guys. I greatly appreciate your input.

I am not sure, if I can explain the business case in the space available here. Its pretty complicated. But I can try to...