Hi Tim, no problem and thanks for the great example you covered at the aforementioned URL. It saved me a lot of head scratching and googling!

I have resolved the issue with the following example:

http://www.timmitchell.net/post/2010/08/23/ssis-conditional-file-processing-in-a-foreach-loop/

What I realised was that I needed to just ignore the current log file which gets created daily, so using...

Many thanks happycat59, I will give this a go today and ley you know how I get on.

Thanks again.

Hi Shawn,

The link to the IIS forum post is: http://forums.iis.net/t/1217618.aspx?IIS+logging

I agree that would have been helpful.

Kind regards,

Adam

Hi All,

I have managed to resolve this issue.

The problem was being caused by a gpo that had removed the permisions for "Network Service" (used at discovery point).

I followed this article...

Hi,

Thank you for your response.

Yes I can see the services for each instance if I run a "Net Start" from cmd line.

Kind regards,

Adam

Hi Craig,

That's a really good point and one I will certainly use. It makes a lot of sense to do check the last run date. I am just really suprised...

Hi John,

Thanks for you reply.

I am not trying to pass parameters to the the agent, rather set parameters/variables/overrides within the agent. There is a new parameter section with SQL Intergration...

You could always move the existing backup files to another location (local, network or removable) and if a restore requires the files needed just use the prompt for files...

Hi Lowell, apologies for the delayed response... Been tied up with DPM backup issues!! Yes that's great just what I was looking for, I will give it a go on...

Hi Chris

Thanks for your reply, can you expand on local user groups... I am the only DBA in my company.... well the only person who deals with databases so I...

I have a full, diff and all transaction log backups that are required to perform the point in time restore, the two issue I am having are:

1, The full backups...

Thankyou for your replies, definitely something to think about with regards to the file corruption!!

Do you have any thoughts on the initial question? Which essentially is: Can you restore a...