Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

This question already has an answer here:

This will be only for testing and developing. I have a 100 GB DB I am working on and need a sanbox envorinment. The only hardware I have is a desktop with 3GB and 32bit. I am able to install SQL 2008 Ent 32-bit (trial) on XP with no issues. Will there be any problems starting the service once I get the large DB restored?

share|improve this question

marked as duplicate by MDMarra, mdpc, Jenny D, Bryan, Tim Brigham Apr 8 '13 at 19:55

This question has been asked before and already has an answer. If those answers do not fully address your question, please ask a new question.

    
Why not install a Server 2008r2 trial also and add more ram? –  chewbakka Apr 8 '13 at 17:55

4 Answers 4

Will you be able to restore the database? Yes. Will the database be accessible so that you can run queries against it? Yes. Will the performance suck? Probably

The answer to that last one really depends on how much data you need to load into memory. Given that you've only got 3 Gigs of RAM installed, you've probably got about 1 Gig of memory for SQL Server to use. So if your testing only needs a few rows of data, then everything will be just fine. However if your testing needs to run queries over all of the data then performance will be horrible as you'll be thrashing the disks.

share|improve this answer

Since this is for a test environment, you might as well just try it out and see if it works to your satisfaction. No amount of speculation will give you as good of an answer as actually doing it.

share|improve this answer

Yes, it will run.

How fast however depends on your working data set. 3GB RAM (and about 1GB used for the OS) is not much to run SQL on.

share|improve this answer

Our current production system is running a 250 GB on average filesize database for a web application with no signs of performance issues. Our setup is a SQL 2005 Workgroup running on 2003 SBS with 3.25 GB RAM

We are in the process of upgrading to SQL Server 2012 and Windows Server 2012 with 32 GB of RAM.

share|improve this answer

Not the answer you're looking for? Browse other questions tagged or ask your own question.