Thursday, August 02, 2012 5:12 PMI am creating a website that is going to be big (perhaps loaded with 10s of thousands of pictures, profiles, and a lot of legal documents. How do I know if I need a dedicated server or can do with just a shared server? Second question, if I start with a shared server and later find it is not big enough, is there any problems in moving my files from a shared server to a dedicated server? Thanks.
Friday, August 03, 2012 5:56 AM
yes you can start with a shared Server there after you can upgrade to a Dedicated Server,
there will be no problem from Migration from shared server to dedicated Server,use backup and restore when migrating, but take care with the edition levels of the SQL Server
Ramesh Babu Vavilla MCTS,MSBI
Friday, August 03, 2012 10:34 AMModerator
Don't forget that the datafiles of the SQL Server Express 2005 and 2008 are limited to 3 GB , for 2008 R2 , the limit is 10 GB. But you have always the possibility to store your pictures/documents in the FILESTREAM system for 2008 , 200 R2 and 2012. In this case, the data stored in the Filestream system are not included in the limit of 3 or 10 GB limit.But the access (SELECT/UPDATE/DELETE is more complicated.
With a SQL Server Express, you may have a limit related to size of the memory that SQL Server can use : 1 GB, which could have an impact on the performances ( if you have complicated queries or many connections or if you are using a SQL Server shared by many applications using different databases ).
Please, could you provide informations about the version (2005/2008/2008 R2/2012) and edition (Express,Express with Advanced services or others... ) of your SQL Server and the full version/edition of the operating system on which your SQL Server is installed ?
Have a nice day
Mark Post as helpful if it provides any help.Otherwise,leave it as it is.
- Marked As Answer by Maggie LuoMicrosoft Contingent Staff, Moderator Tuesday, August 21, 2012 8:10 PM