You can get the maximum capacities for SQL Server here: http://msdn.microsoft.com/en-us/library/ms143432.aspx

For MySQL, I assume you have some documentation somewhere that will show you.

For DTS, save as structured storage files. Use the runtime to execute them: http://msdn.microsoft.com/en-us/library/bb500440.aspx

Note that SQL 11 will not have support for DTS

I tend to agree with Toby. R5 has a write penalty, and to get large storage, you need to move to a SAN, both for IOPS performance and capacity.

Craig Farrell (12/29/2010)

---

Happy holidays all. Just got back from my Christmas vacation. I didn't bother throwing backup into that thread because... well... I didn't have anything to say...

Perhaps you want to explain what you are trying to do in the database from a logical perspective, rather than saying you want a login to own a schema. What...

A login is a server principal. That login does not have rights to the database in question. Check your permissions.

I'd highly disagree with this. Just because it can be done...

My $0.02 added.

Do the databases exist now? Are they in use?

I dislike multiple instances because I have to make a hard decision about how to split memory among the instances, but you...

Brandie Tarvin (12/29/2010)

---

Okay. WIT 24 hours of PASS is accepting abstracts for March. I'm assuming this is Pre-Rally 24 hours of PASS (haven't had a chance to double-check the dates)....

paul.knibbs (12/29/2010)

---

Jeff Moden (12/28/2010)

I just love the way companies like MS force you to upgrade... at gunpoint. They'll still sell you stuff so it's not like they're all holy...

The images have been corrected. My apologies for the issues.

WayneS (12/28/2010)

---

Okay, let's talk about blogging. I've seen a few posts from time to time, but I don't recall seeing anything dealing with:

(From a higher level) How to set up...

Backup history is here:http://msdn.microsoft.com/en-us/library/ms188653.aspx

A backup is typically run as a job, so any information is available as part of job history: http://msdn.microsoft.com/en-US/library/ms174997%28v=SQL.90%29.aspx

Doh!