I am unable to connect to the local server if i use Back task in SSIS

I am executing the package from sql server 2008 r2 and want its path to be at the another server where only sql server 2005 is there will that be...

Please suggest me how to troubleshoot and what exactly the problem is

Hope these links will help you

http://blogs.msdn.com/b/psssql/archive/2008/04/11/how-it-works-sql-server-checkpoint-flushcache-outstanding-i-o-target.aspx

http://sqlblog.com/blogs/linchi_shea/archive/2007/08/17/performance-impact-frequent-manual-checkpoints-and-their-i-o-behavior.aspx

Yes it wont be fast enough if you are using full recovery model.I will have to check whether dirty pages have been flushed to disk or not first and other...

Checkpoints flush dirty data pages from the buffer cache of the current database to disk. This minimizes the active portion of the log that must be processed during a full...

ya very true...you can carefully check and go according to that...

use sql profiler..tune all your queries/sp which are taking more time by applying recomendations given by the tuning advisor..if it still does not work then check in books online it...

sometmes the .bak file will be corrupted...try attaching another .bak file

Ya thats the way it should be

Need to be configured again