This is a good starting point...

http://www.microsoft.com/downloads/details.aspx?FamilyID=818234dc-a17b-4f09-b282-c6830fead499

I would agree, given a choice I would go with SQL 2008.

I installed SP3 on 7 development servers last night and didn't have any issues. I'm in the process of planning a roll-out on Production. Anyone have any issues with this?

The...

Microsoft has a SQL 2005 FOC document which can be downloaded from

http://www.microsoft.com/downloads/details.aspx?FamilyID=818234dc-a17b-4f09-b282-c6830fead499&displaylang=en

Thanks for all your responses.

I tried to execute the maintenance plan in a development environment and have been able to confirm the database grows from 26 gb to 70 gb...

I'm currently using the default database reindex plan.

Do you mean using some custom scripts for the reindexing? Can you point me to some scripts that are out there as a...

Not really, here's the break up

340CLUSTERED

327HEAP

474NONCLUSTERED

The DB size on 2/1 was 46GB and the 12GB growth was over the duration of the reindex. So someone or some process had to...

That is correct, however, how do you explain the growth of the data file when there is enough of free space within the existing mdf.

The database size is 46GB, the...

I've done this already. However you can't restrict a server admin from stopping SQL Services from Cluster Administrator and doing what he wants to.

The good thing is this was still...

The guy who made created this mess for me was apparently on the wrong box. He did manage to take out another 3 application databases other than tempdb.

Thanks for all...

The instance is up and running. It was a permissions issue after all. Here's what I had to do...

I gave Full Control to the service account on the root parent...

i'm executing sqlservr.exe -c -f

On trying the command you posted, i get an Access is denied error, however, i verified the service account has access to that path.

The tempdb database wasn't created and am logged in with the service account and can open the master db log file in notepad so it shouldn't be a permissions issue.

All the other system databases are in the original folders as expected. I've logged in with the service account to make sure i can access the drive (different from tempdb)...

2009-02-04 13:22:49.60 spid4s SQL Server started in single-user mode. This an informational message only. No user action is required.

2009-02-04 13:22:49.60 spid4s ...