Building a SQL 2005 Database on Windows 2003

Posted on 22. Sep, 2009 by in Database

Print This Post Print This Post

VN:F [1.6.3_896]
Rating: 3.8/10 (9 votes cast)

This document outlines the steps to building a general purpose Microsoft SQL Server 2005 database on Windows Server 2003 Enterprise.

Formatting Disks

In this example we will be working with a single 80 GB volume. Most likely in a production environment you will be storing your database on mirrored storage and/or a SAN. Ideally, it is best to store the OS and the data files on separate physical disks. However, in this example we will simply separate them by creating partitions.

Below are the partitions that will be used in this build. These sizes are for illustration purposes. The actual sizes will vary depending on the intended use of the database.


  • C – Windows – 14 GB
  • G – Data – 16 GB
  • H – Backups – 32 GB
  • L – Logs – 12 GB
  • Z – Apps – 6 GB

During the Windows installation we will create a 14 GB partition for the windows C drive. Press C to create a new partition.

SQL-2009-08-28-10-36-47

Enter 14000 and press Enter

SQL-2009-08-28-10-36-59

We will leave the rest of the disk unformatted for now, and use disk manager to create the rest of the partitions after the OS is installed. Press Enter to instal Windows on this partition.

SQL-2009-08-28-10-37-12

After Windows is installed Right Click on My Computer and select Manage. Then click on Disk Management.

Right click on the available part of the disk to create the first partition.

SQL-2009-08-28-11-21-36

For the first drive (G drive) we will create a primary partition

SQL-2009-08-28-11-28-06

Enter the size for the g drive

SQL-2009-08-28-11-28-15

Select drive letter

SQL-2009-08-28-11-28-27

Leave defaults, enter drive label

SQL-2009-08-28-11-28-40

Since we only have one disk in this example, and Windows only allows up to 4 primary partitions per disk, we will need to use an extended partition and create logical drives for the H and the L.

Right click on the available disk space and select New partition. This time choose extended partition

SQL-2009-08-28-11-30-48

Assign enough space to cover the H (backups) and the L (logs) drives. In this case 44 GB.

After the extended partition is created, right click on it and create the two logical partitions on top of it.

SQL-2009-08-28-11-32-38

Use the remaining space for the Z (apps) drive.

When finished you should have the following drives in My Computer

SQL-2009-08-28-11-36-32

After formatting the drives, we will run windows update to make sure we have all the latest patches. Open the browser and goto windowsupdate.microsoft.com and follow prompts to update system.

SQL-2009-08-28-11-37-36

VN:F [1.6.3_896]
Rating: 3.8/10 (9 votes cast)

Tags: , ,

Pages: 1 2 3

Print This Post Print This Post

Leave a reply