Thanks Mark, it works!

Hi All,

Thanks for all your help!

Thanks for help. I even ran the maintenance plan itself and it ran and finish within 2 second and did nothing.

but it report success. I checked all steps inside...

In Backup Database Task, there is option for connection- local server connection and target server connection

I find that the problem plan was using target server connction that's not even kick...

Thanks, I'm going to run profiler. by the way, what event in profiler I should choose to monitor this?

thank you so much Bledu!

Thank you, I will try SSIS...

Thanks for the reply. I didn't know there is such kind of function. I will do some more research see if asp.net has this function too.

Thanks for the reply, let me try to understand it, thanks!

Thanks for the reply. (sorry I didn't count correctly. expected result should be 1/1/05-1/3/05 and 5/1/05-5/7/05, what I was doing!)

I was able to use the same method, but I'm wondering...

Thanks!