It is a SQL login that is the database owner of both and this login has public and db_owner rights to both databases.

I changed the fillfactor to 80 and the fragmentation went down to 41% but the page size went up to 17. Can someone please explain. This table will never change....

Is there any documentation for 2005?

The column type is int, not null. And it has the primary key, which is the index.

Thank you. I went with moving the distinct to outside of the dbcc reindex. Yes, I needed to rebuild the indexes but we different fillfactors for each table (some...

Yes, we plan on backing up about 3 of those 5 databases and compressing them. One database we will keep a week's worth of backup and when zip'ed they are...

Okay, gotcha on the AWE.

So is the proposed setup that I listed above good enough?

Also, there will be about 5 databases on there. THe biggest is about 11 G.

This server will house development and testing databases. Only about 10 to 15 users at a time. Mostly performing development or testing.

I removed the *.* Hopefully it will work now. If not I found a vb script that deletes old files. I also heard there was a problem with the maintenace...

I forgot to add that I am using sql 2005.

Thank you! Do you prefer one of the other? I just downloaded visio and will play with that a little.

Thanks again!

I did create the backup using the maintenance plan. That was in my original post. The maintenace plan I'm using is over writing the backup from the night before. When...

Okay, I modified the T-SQL of the job and it's putting dbname_YYYYMMDDTIME exactly like that. When backing up it's putting the dbname then 'YYYYMMDDTIME', instead of the actual data and...

Thank you so much for your quick response. I think I understand. But have a few questions. 🙂

Can you tell me what is the T-SQL for the task to...