Thanks Tim.

Yes, I was able to FTP this file by using CoreFTP Lite... so I know the FTP site is up, the login is good etc.

But I'm really struggling to...

Thanks Sahi.

I do not have a licensed copy of Winzip. That is why I was hoping SSIS had a builtin tool for zipping, but no.

John

Thanks Vivien.

I was afraid my question was not clear.

I want to send only failure notifications to myself, but send ALL types of completions to another email addy. Dont think SQL...

This worked perfectly, rbarryyoung.

Just what I needed. Thanks

Thanks rbarryyoung. The best and easiest solution I've had yet.

I'll post back tomorrow.

John

balbirsinghsodhi,

I have had this problem in 2005 maint plans too. it is a known issue.

Make certain SQL Server 2005 has Service Pack 2 installed. If it already has SP2, search...

In the 3 companies I've worked for, none had the Enterprise Edition.

It would be interesting to see a survey of the percentages of DBAs who have only Standard Edition versus...

At first glance, I tend to disagree. I don't always know which features will be used in the long-term on a new SQL Server. So I install AS,IS and RS....

And if mirroring is your goal, it works well I've found.

Perform the restore as above with NORECOVERY.

It must be in 'restoring' mode to activate mirroring. Then create your Endpoints...

As webooth says, you can assign multiple email addresses to an operator. I think that's an undocumented "feature" and I use it.

On my servers, I usually create 2 operators: DBA...

Kirk, try this.

Find (or ask your system admin to create one) a domain account that has very strong permissions. I use an account here named DomainName\sqlexec.

You will NOT need to...

Thanks Matt.

I've worked with replication a good bit but I needed to be reminded of that sp.

This is what worked:

exec sp_removedbreplication 'EventsManager', 'both';

then DBCC OPENTRAN showed no active open trans

a...

SSCrazy,

I set the db to Simple.

Then ran the DBCC OPENTRAN...

Transaction information for database 'EventsManager'.

Replicated Transaction Information:

Oldest distributed LSN ...

SQLBill - It is now in Simple, before I started the backup. I have tried what you suggested. But it was originally Full causing the t-log to grow

"then try the...

SScrazy,

I've already started a database backup and backup log then truncate log. But I don't expect this to work because of the uncommitted transactions as you mention.

I did run DBCC...