Please start any new threads on our new site at We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 Design of database server

Author  Topic 

Starting Member

1 Post

Posted - 2009-11-25 : 16:44:32
I need help with design of database server.
Platform : MS SQL 2000 SE
OS : Windows server 2003 x32 or x64
Size of database: 10GB
Number of clients: 30
Dedicated for ERP system

1. I have MS SQL 2000 SE - support only 2GB RAM - Is it enough?
2. What raid configuration?
3. How many disks?
4. Is the effective two disk array, one for OS and LDF file and one for MDF file?


Master Smack Fu Yak Hacker

2179 Posts

Posted - 2009-11-29 : 09:05:38
My standard is to split :
2)Data files
3)Logs files

Jack Vamvas
-------------------- (IT jobs)
Go to Top of Page

- Advertisement -