specification for laptop to run SQL Server 2000

[collierd]

I plan to use SQL 2000 on a laptop

To avoid any pitfalls with the usual recommended specification i.e. under/over spec'd does anybody have a recommendation for the specification of a laptop in order for it to sucessfully run SQL Server 2000
i.e. OS, memory, disk space, processor etc

Thanks

Damian

 

[JamesLean]

Look up "minimum requirements" in the BOL index.

The spec of machine is entirely dependent on the size/scale of the databases you intend to run on it.

In general, SQL Server will eat as much RAM as you can throw at it and if money is an issue then this is the area you should beef up first.

--James

 

[FoxyBOA]

Computer: Intel or compatiblePentium 166 MHz or higher.
Memory (RAM)[1]:
-Enterprise Edition: 64 MB minimum, 128 MB or more recommended
-Standard Edition: 64 MB minimum
-Personal Edition: 64 MB minimum on Windows 2000, 32 MB minimum on all other operating systems
-Developer Edition: 64 MB minimum
-Desktop Engine: 64 MB minimum on Windows 2000, 32 MB minimum on all other operating systems
Hard disk space[2]:
-SQL Server database components: 95 to 270 MB, 250 MB typical
-Analysis Services: 50 MB minimum, 130 MB typical
-English Query: 80 MB
-Desktop Engine only: 44 MB
Monitor:VGA or higher resolution 800x600 or higher resolution required for the SQL Server graphical tools
Pointing device:Microsoft Mouse or compatible
CD-ROM drive:Required

 

[ecobb]

Depends on what version of SQL Server you want to run on what OS....

Are you going to put Server 2000 on your laptop, or do you have XP or 2000 Pro. Each one of these require a different version of SQL Server.

Check this out on Microsoft's web site, it should answer any questions you have:

http://www.microsoft.com/sql/evaluation/sysreqs/2000/default.asp

Hope this helps