Problem solved:

It's 2003 R2 and 64kb is the largest available. The partition will only be holding DB's.

EdVassie (3/16/2009)

---

The best advice is to go for 64-bit and SQL Server 2008 on Windows 2008. This will give you an operating platform that will stay current technology for...

Jeff Moden (3/15/2009)

---

Heh... if you were in charge of the health of a fancy race car, you wouldn't allow people to use it to haul manure. Why would anyone...

A very good point, but unfortunately one that I have no control over.

I'm the network/server admin so I get to provide a...

Thanks both.

On the backup to UNC issue, I guess I'll sound like a smart-*** but we have verify on, and there's little goes on at that time of night (not...

tosscrosby (3/17/2008)

---

Differentials are not an option in the maintenance plan but you can script it into a job. Daily index rebuilds - is that really necessary for your environment? Backups...

Thanks for the reply and information.

The article on shrinking makes a lot of sense. Presumably whenever SQL deletes anything the space is treated as white space and is re-used...