Homebrew1, thanks for the question back. I checked with the vendor and just recently they approved SP3. Maybe that's what we need to do to get around this problem. I...

Thanks for the heads up on the summary.txt file. It displays the error :

MSI (s) (A0!8C) [19:04:09:615]: Product: Microsoft SQL Server 2005 -- Error 29512. SQL Server Setup was...

Thanks for the link, Adiga. I will get SPs in line first and then try maintenance plan without SSIS loaded.

I know I have to get the versions so they're the same ; I'm trying to get the vendor to agree to SQL 2005 SP3 for both servers. The server...

Yes ... and Yes

We now have the .mdf and .ldf files for the production db and tempdb all on separate disk arrays. The .mdf is a Raid 1 + 0 configuration spread over...

Well, so far, so good. We have made it through our first month end closing with barely a word from the user community about poor performance. This is the first...

Thank you both for your input. Points well taken. We did have in our plan to move tempdb, .ldf and .mdf to separate volumes. It was the multiple file proposal...

Jack,

Thanks for the opinion. So, if I'm reading you right, data access is data access regardless if it's "minimal". Our vendor is...

Thanks to everyone for their comments on our issue ... This particular one seemed to be the solution, at least it seems to be. We noticed that when our BU...