Hi AJ Ahrens,

Not sure what you mean by "didn't copy the database as well"

The question I have is where did all this come from - the trans log never got bigger then 300 while I had it in the bulk logged model, I...

I changed the recovery model to Bulk-Logged and ran the DBCC REINDEX in batches late last night - first excluding all the large tables that have clustered indexes.  The trans log...

Thanks,  Will try that.

Yes, Agreed - that I could change the recovery to 'bulk logged" from "Full", which is what I have it set to know - but would'nt that cause my log shipping...

Thanks Phill, thats what I needed. Appreciate the Quick response.

Thanks Allen, will look into it.

Hi vkpalivela,

Thanks - that did the trick - help is greatly appreciated. Can you please explain the query real quick.

Thanks guys - appreciate the feedback

Thank You Mark. That does do the trick.

How about something like this - would'nt this do the trick as well:

delete from table_name

where (Pk_value )

not in

( select min(pk_value)

...

I restarted SQL Server Service and it did not work. So then I created a new domain user, a new exchange account, new profile etc etc and restarted the...

Yep. SQL Mail is configured fine. I might reebot the server tonight. Everything else looks good to me.

I even changed to "use Windows NT authentication" in the connection tab of the SQL Server Agent and restarted SQL Agent through the cluster admin - its the same. It...

Thanks for your help guys. Like I mentioned in my starting post, I already changed the sa PW to the new one in connection Tab of the SQL Server...