Excellent. Thank you all for the information.

Thanks for the info!

Is there a range that I can open or do I always need to check what is assigned?

*Note to other readers you can see the port used...

I'd recommend reading a few tips on partitions to get an idea of how they work. Then you can make a decision if you want to remove those partitions.

http://www.mssqltips.com/sql-server-tip-category/65/partitioning/[/url]

Visit that...

The second script will move the data in that file to another file in the same filegroup. It will not delete data.

If you have multiple filegroups and you want...

This script from HERE[/url] will tell you good stats on your files

DECLARE @DBInfo TABLE

( ServerName VARCHAR(100),

DatabaseName VARCHAR(100),

FileSizeMB INT,

LogicalFileName sysname,

PhysicalFileName NVARCHAR(520),...

You can use the MERGE statement for the data since you're using 2008 R2. It will take quite some time to script this all out. More Info: MSDN: MERGE

With 500+...

I personally have yet to find anything that PS can't do that VBScript/Batch can.