Creating and dropping temporary tables forces a recompile.

You may also want to retrieve all of the current SQL Server configurations. You can do it through the gui, but to quickly get a complete list that you can...

Prepare for the worst case, that the server or databases fail to come online, by making fresh backups of all of your databases. This just for starters so that you...

I am not sure how you configured your connection, but one thing you can do is check the connection manager. There is a connection method that can actually ignore any...

Have you tried running the package outside of SQL Server? If so, what are the results?

Just to expand on the above... the transaction logs are also applied during the filegroup restore which ensures database consistency. I do not believe a filegroup restore can be...

When restoring from filegroups you need to also have all the tlog backups, spanning the entire time/date range of your files.

Let us know how it goes.

One of the standard SSMS reports is "Configuration Changes History". Running this report will give you a list of updates to your SQL Server configuration over time.

ramchandra - your link is not working.

Did you use a 3rd party tool to create the backups that need to be cleaned up?

If so, that could be the problem since that maintenance cleanup task (in...

Without knowing the details of your situation...

You might want to start by checking to see if sql server agent is running and make sure it is using the right...

Glad I could help... I wonder how many of us have run into this gotcha?

Placed your rss link in my Live Bookmarks. I think staying tuned in (reading SQL ServerCentral, blogs, etc.) as well as the rss feed I will be all set....

Also, you might want to check the file extension you set up for the task. It needs to be set as "bak" without the dot (.bak).