What is confusing you about it?

Use the "select index filegroup" option of the wizard when creating the index.

Depends what the commands where going.

You should really debug what they are going using the sql text dmv.

Shrinking then rebuilding is ok it will add space to the MDF as the rebuild will need space to do the sorts etc.

But you should really add enough space to...

Well if they are at 25GB and they cant grow past 25GB then why bother shrinking? Do you need the space back to the OS for some reason? ...

You need to add enough free space in all the files you shrink.

So if your DB has 10 files, you run it 10 times for each file in the DB.

You...

ALTER DATABASE .... MODIFY FILE (NAME = '.....', SIZE = 45GB) --Put the name of the logical file from sp_helpfile in the command

As the object is deleted, it doesn't release the space back to the operating system, as grabbing space and growing the database is a very costly and expensive operation.

Your options...

You got lucky detaching and attaching a single file DB, SQL will not always do this successfully. The log is not a throw away file, it is critical to...

post the actual execution plan of the query.

post the create table definitions of the visit and result tables along with all the indexes.

Please take a look at the two links...

Hakuna Matata (1/31/2013)

---

The data & log file have different logical names FSB & FSB_LOG. It was a typo error.

I tried the ALTER DATABASE FSH MODIFY FILE (NAME = FSH_data,...

Both your data file and log file have the same logical name, that database shouldnt of created.

ALTER DATABASE FSH MODIFY FILE (FILENAME = 'G:\Database\FSH\FSH.mdf', SIZE = 45GB)

Whats the output of the following

select * from sys.master_files where database_id = DB_ID('FSH')

ALTER DATABASE FSH MODIFY FILE (NAME = FSH_data, SIZE = 100000MB);

Only if your CEO has the right roles on SQL or knows of an account that does.

To be able to send mail you need to be part of the DatabaseMailUserRole...

What is the growth rate? Percentage? MB? How much?

Manually add some space to the files which live in the primary file group.