Lowell, thanks for the SQL code -- the first SELECT statement -- that was very helpful so that I don't have open each NT group manually to see what's...

Ankur, thanks for you suggestion and that was the problem - one pf the NT group has db_denywriter checked.

Thanks to all for helping me.

Thanks for getting back to me. There is no triggers either at table level or database level. Are there anything else I should check ?

I prefer solution (a) as well because we don't really know how OS terminate the SQL service.

Thanks to both of you and have a nice weekend.

Thank you all for responding my question. I really appreciate it.

The problem started last week. From OS level, we were getting either "...file being used by another process" or "...cannot...

I'm having the same error except my was a differential backup. The error comes from a job that executes a maintenance plan which deletes BAK files older then 24 hrs...

Thank you Gail. I really appreciate your help.

This is a production server and we have very large databases there. Having automatic DBCC CHECKDB enabled will slow down the server significantly.

Redo the maintenance plan with a simple database backup and see if it works.

At work, I have a job that have two steps like yours. The first is a DTS...

Is it possible that step 1 is causing step 2 to fail ? Try to remove step1 and see if it works.

I mean file fragmentation.

I noticed the backup file size is always smaller than the actual database file. That's why I thought if SQL Backup will defrag its files.

What if I...

Thank you anyway. Does anybody else have any clue ?

Is this applies only to SQL 2008 ? because I din't have problem restoring this same database to SQL 2005.

I ran Upgrade Adviser but I didn't get any errors. There are two warnings but they are related to full-text search which we don't even use.

One thing I didn't mention...

Does anybody had this error before ?