Thanks all. I was able to somewhat replicate this. This is happening only during night after 1 am , and at this time the DB backup Job executes for...

Anymore views anyone....

Thanks for the inputs.

I tried increasing the timeout to a 1 hour , but still get the same issue.

If the Query plans are being generated differently on 2 environments. then...

OK , so the options are to use command line or call a SQL Job from .net.

Thank you all

I use

Microsoft.SqlServer.Dts.Runtime.Package.Execute()

How do I control dtexec to run in 32 bit from c# code?.

We cant have another DB due to various constraints costing etc...

So I want suggestions for compacting on the same DB. New DB option is known.

Sorry , my bad. It's SQL Server 2005 , in the middle migrating from 2005 to 2008 r2 :).

I will check if this is set on my DB and will...

So if Auto_Close is not in SQL Server 2005 r2, then this is not the cause in my case.

The reason I ask this is - the sql user ID is...

I am using Integrated Security = SSPI now, unable to resolve this error.

Yes, no problems with SQL instance

Any pointers or feedback ?

Thanks for your reply, I understand from security point of view. So design wise it wont affect SQL server if one account for all the databases.

No one?, not even 1 ?

Hi Kristen,

PFB my inline comments.

Is this a reporting database?

[Yes this is will be used for Reporting]

What do the users want? A once-a-day known-time-of-day restore? or a continuously-restoring-but-not-current?

[One day old data...

No views anyone?