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?

I don't think employers have to promote general welfare. It was a benefit the unions forced and companies started to offer to compete for workers.

With the way healthcare is changing...

Are you not backing up to different files each day? Going to the same file is a bad idea.

If you use different files, set a script, prob VB or Powershell,...

I have no idea, but I'd call PSS. Something is wrong here and you don't want to be running without the ability to backup or recover.

It's worth the $250.

Something definitely happened. Either someone did a load, index rebuild, some activity that moved lots of pages around.

Andras is correct. What happened is the customer had two files specified in the backup dialog and ended up with a "striped" backup, with both files containing part of the...

It sounds like a file conflict.

Can you manually restore the file.