Thank you, that worked out perfectly. I appreciate your help!

Jeff

You can find answers to a lot of your questions in this forum post:

http://www.sqlservercentral.com/Forums/Topic679453-146-1.aspx

I did not have any trouble adding secondary data files (.ndf) with autogrow turned on,...

What service pack are you on? There was a bug that was partially corrected in SP1 and fully corrected in SP2 that corrects this issue.

Is there a disk quota in place?

sys.master_files should give you a system wide catalogue of data and log files being used.

Thank you, that looks like a great script. We will definitely be looking at ways to implement it once our db is cleaned up.

Thanks again for your help.

Jeff

In our version of SQL Server that value is not available to be set in the maintenance plan, but it got me looking in the right place. A query of...

Thanks for the input. I am able to shrink the various data files to remove the free space, but that still leaves me with the question of what happened to...

The Trans Log is backing up every 1/2 hour and truncates. We have tried to shrink the database, but it never reduces in size.

sp_spaceused shows me the following:

database_namedatabase_sizeunallocated space

mas500_app27825.81...