Brian Knight has written two well received books about SSIS. He's a business partner of mine, but also a SQL Server MVP and lots of people have liked the books.

Search...

http://support.microsoft.com/kb/274750

First, post these in the DTS forum.

Second, if you need to drop the FK, you can drop it with an Execute SQL task set up to run before you drop...

Is this still happening? Any resolution?

Could it be scheduled twice?

Sorry for the delay here. Are you looking to backup the primary or secondary?

Set up a Profiler trace (or better yet, server side trace). You can search in Books Online under Profiler (http://msdn2.microsoft.com/en-us/library/ms173757.aspx)

You might want to just monitor the batches and look for...

Please let us know if you find anything.

Has the server been rebooted?

The server does get recovered every time and it's possible if there were lots of changes that needed to...

Please let us know. I never checked before, but I wouldn't be surprised if some process is using temp space as temporary storage. I'd expect them to clean up, however.

Are...

Recovery is the process of rolling forward and rolling back when a database starts. It is different from the recovery model. The advice above (both) is what you would follow...

The database restore would trigger a DDL event since there is essentially a new database being created (and one being dropped).

You have to re-run the restore and use the WITH NORECOVERY or STANDBY options during the restore.

You should have a primary key in any case. Even a surrogate to allow you to get to every row.

Brendan,

I don't think this will help you. SPs typically aren't "upgradeable". Usually you can try to uninstall, but often you have to remove SQL Server, reinstall, then reattach your dbs....

I haven't seen this. Unless there were some transaction that prevented access to a table, I don't know what would take so long.

I'd reboot the server to clear it if...

Does the database appear in SSMS?