Sign in
 
Home20122008 R2200820052000LibraryForums
SQL Server >
> 
> 
Server Size requirement

Answered Server Size requirement

  • Thursday, August 02, 2012 5:12 PM
     
     
    Sign In to Vote
    0
    I 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.
     

All Replies

  • Friday, August 03, 2012 5:56 AM
     
     
    Sign In to Vote
    0

    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 AM
    Moderator
     
     Answered
    Sign In to Vote
    0

    Hello,

    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.