I think so, thanks.

So, for every hour of the day, I'll have 4 tran log backup files?

Am I missing something?

the copy table you're trying to create off of the original table, does it need to have the data in it, or just the table schema?

Hello Nicole. My name is Gary Arutyunyan, and I'm a SQL Server professional looking for work in the Los Angeles area. When you get a chance, I'd like to send...

that's the thing. how do I set up mail profile and client?

I need to be able to receive emails anytime a job fails on my production server(s)

thanks

email notifications

I have a mail server. can I configure that server to send out notifications, from my production servers?

Excellent, thank you Andy.

BTW-- this site is awesome