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.
| Author |
Topic |
|
myersgg
Starting Member
3 Posts |
 Posted - 2008-03-17 : 16:37:53
|
| I am currently using SQL Server 2005 Express to run a social networking website on a dedicated server (Windows Server 2003, code is written in ASP.net). Obviously express is too limited to run this site, but for now I am still getting the site operational so the demands are low. Soon I will begin advertising and adding many users to the site - can anyone recommend a version of SQL Server that I would need? My programmers say I should go with enterprise, but that seems overkill (and my hosting provider - theplanet.com does not even offer it). Would workgroup be enough, or should I go with standard edition?To be honest I do not trust my programmers experience with SQL server which is why I am asking for help here (they are outsourced from India, and I am becoming more and more convinced that I need an onshore IT manager for them - finding that is another issue...). Also, are there built in backup features with SQL Server? My programmers told me recently that they will need to put in significant work to setup a backup system, but it seems to me like one might already be built in.Thanks for your help,Greg |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-03-17 : 16:46:42
|
"To be honest I do not trust my programmers experience with SQL server which is why I am asking for help here (they are outsourced from India, and I am becoming more and more convinced that I need an onshore IT manager for them - finding that is another issue...)." Look at this:http://www.microsoft.com/sql/prodinfo/features/compare-features.mspxWhat do you mean by builtin backup features? Can you explain clearly? |
 |
|
|
myersgg
Starting Member
3 Posts |
Posted - 2008-03-17 : 16:56:16
|
| Thanks for the reply - I have seen the features comparison, but I guess I was more asking what people thought would be necessary to run a social networking type website? I would have around 10,000-20,000 users to start - assuming all goes well :) I am a bit curious as to what the standard is out there (although I realize many such sites go with LAMP which isn't an option for me since I went with ASP.NET).As for backup, I need a way to save the data in the database to another location in case something happens to my server...I wouldn't want everyone losing all of their information and never using my site again.Greg |
|
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
Posted - 2008-03-17 : 17:20:27
|
| All versions of SQL Server come with built-in backups. You need a regular server edition (Workgroup, Standard, or Enterprise) to get the SQL Server Agent to be able to schedule automatic backups.If you want backups to tape, you will have to work that out with your hosting company.I don't that it is a good idea to depend on the advice of developers for SQL Server administration issues. They may mean well, but unless they have years of experience administering SQL Server, they are not the ones to talk to about these issues.Check around to see if you can get the services of a qualified DBA to help you setup and maintain backups.CODO ERGO SUM |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-03-17 : 17:32:37
|
| 64-bit(Resolves Memory contention issues)Standard edition will be good for you if you don't wanna go for Enterprise edition. Plus you can have additional features like Database mirroring. |
|
|
|
myersgg
Starting Member
3 Posts |
Posted - 2008-03-17 : 17:34:38
|
| Thanks for the info - yeah I figured they would come with a system to do backups. Any idea where I might find a DBA to help with backups etc? I really think I need an IT manager who can help with DBA and general coding issues in ASP.NET, etc. The problem is that my company is still small right now, so I only need someone part time at first, and as we grow obviously I'd need them to work more and more. Any ideas where I would look to find someone like this or what a reasonable cost would be for them?Thanks,Greg |
|
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2008-03-18 : 04:45:17
|
| Have you considered hosting your db at a 3rd party hosting service , who can handle backups etcJack Vamvas--------------------Search IT jobs from multiple sources- http://www.ITjobfeed.com |
|
|
|
|
|
|
|
|
Using SQL Server to run Social Networking Website