I did the shrink last night, pretty much in the same manner you posted. I was getting pretty frustrated; shrink, don't shrink, autougrow, don't autogrow, etc... I just went with...

If I don't shrink the log how do I get my 20G log file back down to the 6G it should be? I have over 530 VLF's on this database....

One more question. I have Visual Studio 2005 installed, as part of the SQL Server 2005 install we setup. Is that the same as Visual Studio .Net?

Ok here is our game plane.

1.) Backup the log file

2.) Set Recovery to Simple

3.) Shrink the log

4.) Set Recovery back to FULL

5.) Run a full backup

6.) Remove the Shrink Database...

We read the article by Kimberly Tripp. As suggested we ran DBCC LOGINFO on the db and it returned 536 records (VLF's).

Honestly I can't tell you why the maintenace job included the shrink database. Also, we took your advice and compared the tables on the Reorg to Rebuild and they are...

We recently inherited this production db. There was a weekly maintenance plan set up, but it had not been executed successfully since originally being setup in '08. However, the daily...

Good advice. I appreciate it.

Thanks

Thanks. Can you point me to some decent training material. I do not see much offered out there.

I appreciate the feedback very much. Our user base is strictly internal at this point, so I will look into Winforms. Again, I appreciate the feedback.

How would one go about building a front end in ASP.NET? I looked on the asp.net website and the download is free. However, which do I download? ASP.NET Framework, ASP.NET...

Thank you. I appreciate the help.

The script I posted worked. However, the database I was using did not have any data in it. I was using it for testing purposes and whoever set it up...

I got it working. Thanks.

How would I get this to work?

SELECT EMP_ID, DATEDIFF(MONTH, START_DATE, END_DATE) AS HISTORY

FROM EMP_HISTORY

WHERE EMP_ID = '253'