You can fix it with the following hotfix:

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

I have applied it and it works fine.

So when the vendor tells you that their product can be used with SQL Server 2005 you can not always take their word for it. 😀

I guess...

I agree with it not being a clean shutdown. As per BOL:

FOR ATTACH requires the following:

All data files (MDF and NDF) must be available.

If multiple log files exist,...

We use Veritas Backup Exec as well and have also had problems with the SQL Server Agent. The best solution is to do SQL Server native backups to disk...

What version of Oracle are you using?

Sometimes in Oracle the service name can be different from the SID. Find out the service name and try putting that in instead of the SID. For example,...

I have applied the hotfix and have not run into any problems yet.

There is a cumulative upgrade package from Microsoft that will fix this problem. Look at the following links.

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

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

What was the blocking process? What processes were they blocking? Are they batch jobs or is someone manually submitting the jobs? You have to know these answers...

I usually wind up changing the owner of the jobs created by the maintenance plan in SQLAgent. I find it to be a big pain in the neck. Every...

Didn't get any responses to this posting, but I found the bug for this problem listed on http://support.microsoft.com/kb/938085. Also a cumulative update package listed on

You need to know why you are shipping the database over to dev every night. If it is just to use for development then overwriting the database nightly might...

I don't always think it is just a matter of costs. If moving to Teradata solves the problems you are having, it could pay itself back in the long...

A year ago I changed jobs from where I worked as an Oracle DBA in a group of around 30 other DBA's (Oracle and non-Oracle). I had a great...

I like the "Oracle 10g DBA" Handbook by Kevin Loney and Bob Bryla. Also if you want UNIX or LINUX books, for quick reference, I like the "UNIX In...