Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 same sql sever for 2 diferent things?

Author  Topic 

kixote
Starting Member

1 Post

Posted - 2009-04-18 : 02:16:36
Hi, I am new to sql and don't know much about it!
I recentelly add a forum to my main website and create a sql server to be able to do that (with godaddy)
I am also going to start a blog and the "program" I will use requires a sql server! Can I use the same sql server for the forum and the blog or I have to create a new one?

Thanks for helping

TG
Master Smack Fu Yak Hacker

6065 Posts

Posted - 2009-04-18 : 08:00:00
You can use the same sql server instance to support multiple applications. It is typical to logically group objects in their own database. Some reasons to use multiple servers are:
- space limitations (doubtful in your case)
- security. Sensitive internal information may be kept on a server that is inaccessible from a public domain.
- isolating environments ie: production, dev, qc, acceptance, etc.
- dedicated service for maximum performance

Be One with the Optimizer
TG
Go to Top of Page
   

- Advertisement -