none
DataBase is too big RRS feed

  • Question

  • hi all

    we have aproblem with sql express 2005, we have a DataBase that has more than 4 Gigs Data, And the SQL Express can not supprot this much of size And our computers are Old and we can't use another version of SQLs, what is your purpose for us, to solve this problem,

    Thanks
    Saturday, April 21, 2012 7:24 PM

Answers

  • if you can't upgrade to SQL Express 2008 - which supports 10GB database size - you've only the option to drop old data or create another database and handle the switch between the database based on a specific criteria.

    Why can't you upgrade to SQL 2008 Express which is free too?

    Saturday, April 21, 2012 7:38 PM
  • Hi Alialem,

    The best option for you is to move to SQL Server 2008 R2 Express Edition which support Data file size of 10 GB. In case if you cannot move to SQL Server 2008 R2 then you need to archive the old data from your existing database to a new database thereby having enough space for your needs.

    Cheers,
    Ashish Kumar Mehta

    Please click the Mark as Answer button if a post solves your problem and Vote as Helpful if a Post is Helpful!

     

    Monday, April 23, 2012 6:54 AM

All replies

  • if you can't upgrade to SQL Express 2008 - which supports 10GB database size - you've only the option to drop old data or create another database and handle the switch between the database based on a specific criteria.

    Why can't you upgrade to SQL 2008 Express which is free too?

    Saturday, April 21, 2012 7:38 PM
  • Hi Alialem,

    The best option for you is to move to SQL Server 2008 R2 Express Edition which support Data file size of 10 GB. In case if you cannot move to SQL Server 2008 R2 then you need to archive the old data from your existing database to a new database thereby having enough space for your needs.

    Cheers,
    Ashish Kumar Mehta

    Please click the Mark as Answer button if a post solves your problem and Vote as Helpful if a Post is Helpful!

     

    Monday, April 23, 2012 6:54 AM
  • we have aproblem with sql express 2005, we have a DataBase that has more than 4 Gigs Data, And the SQL Express can not supprot this much of size And our computers are Old and we can't use another version of SQLs, what is your purpose for us, to solve this problem,

    Purchase SQL Server 2005 Standard Edition.

    Second option, purge data to history tables in history database:

    http://www.sqlusa.com/bestpractices/purge/


    Kalman Toth SQL SERVER & BI TRAINING


    • Edited by Kalman Toth Tuesday, April 24, 2012 11:19 AM
    Tuesday, April 24, 2012 11:17 AM