Building a SQL Server 2008 R2 Database Server

Posted on 16. Mar, 2011 by joshhrob.

This build doc demonstrates the installation of SQL Server 2008 R2 on a 64-bit Windows 2008 R2 server. It also discusses some best practices to consider when planning your database implementation. This Document is divided into the following sections: Things to Consider Pre-Installation Tasks Formatting Drives Setting Page File Create Service Accounts Run SQL Server [...]

Continue Reading

Building a SQL 2005 Database on Windows 2003

Posted on 22. Sep, 2009 by joshhrob.

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 [...]

Continue Reading