Might want to look into tuning the view too.   5 million records really isn't all that much.

I can think of a few of approaches here.   Someone else may be able to offer different input. 

1. use the sp_rename procedure for the table name and the columns.  Good example...

Did any passwords since the last time the agent service was started?  You may want to check and see how SQL Server is trying to log in and what permissions...

Have you tried running the copy commands at the dos prompt?

The only other thing I can think may be an issue is the Proxy account and ntfs security.

Frank.........I've been offline for awhile with a job change.  Good to see you lurking out here.   The client is probably going to have to do this, but I have been...

eosullivan,

That's awesome!!!

Thanks Steve.  Not finding a lot of information out there   But, I believe somewhere I have a cd that contains some old restore...

You can see what is going on with the

DBCC LOGINFO command

sounds like there are transactions out there in some of the virtual log files...

No, but I love the show!!

Easily...no

Log Explorer may be good. 

In some of my databases where there are legal concerns I have triggers that keep track of content changes...who, when, and what.

http://support.microsoft.com/default.aspx?kbid=246133

Not sure if this will work with 6.5.  I am guessing that it will.  I have used this process from Microsoft many of times when migrating.  I prefer to...

I have a nice little C++ compiler that will let me create this upgraded version of notepad with imaging ability.   Problem is that I don't have the time on my...

I'm a big fan of notepad.  In fact, the first database I worked on was a notepad database.   I can do all kinds of neat stuff with it...Save files, word...

Frank, your are the Omnipotent end user   It amazes me how people need their egos 🙂  I was talking to some DBA's a...