I understand the database limit is 200Gb. I have added a few content databases as I expect my content to be in excess of 1Tb at peak usage. Where do I set it such that when the database reaches 200Gb then content starts getting stored on another content db and when that one also reaches 200Gb and so on. Is this something I do in SQL or SharePoint

1TB? I hope you don't have many users or the performance is going to be really slow.

hello in Sharepoint minimum scalability element which can be located in different content database is site collection. I.e. you can't store sub sites (SPWebs) within single site collection in different contend dbs. You need to plan your topology in order to devide your content on various site collections - thus you will be able to scale them. Note that you can't attach site collection to particular content database via Central Administration UI. You can do it either by stsadm createsiteinnewdb operation or via object modelBlog - http://sadomovalex.blogspot.com CAML via C# - http://camlex.codeplex.com Graphs visualization in Sharepoint - http://spgraphviz.codeplex.com