Guys,

I have two different small applications that needs to worked on. I am not sure should i just create one database for both of these or create a separate database for each of them. would you guys advise on what's the advantage and disadvantage of both?

Depends. Are the two applications related? Even if they are, I would still create separate databases. A little more maintenance but well worth it in the long term from a DBA persective and data perspective.

For example, if data is corrupted for one application, it doesn't affect the other data.

Hope this helps...

Scott Klein
Author - Professional SQL Server 2005 XML
http://www.wrox.com/WileyCDA/WroxTit...764597922.html

how does the server performance get affected if you have multiple databases v. few databases within the same SQL Server.