Print-friendly Version

Deployment Guide for Microsoft SQL Server 2005 Database on Sun Storage 7000 Unified Storage System

Application Integration Engineering, Sun Microsystems; July 2009

Introduction

This document describes the steps to create and prepare volumes on a Sun Storage 7000 Unified Storage System to be published to a server running Microsoft Windows 2003 Server, using CIFS or iSCSI with Microsoft SQL Server 2005 databases.

Sun Storage 7000 Unified Storage System can provide storage resources that are published using the CIFS or the iSCSI protocol. Such a shared volume, acting as a CIFS share or as an iSCSI target, respectively, can be used to hold SQL Server database files. This scenario uses Sun Storage 7000 Unified Storage System and Microsoft Windows 2003 Server with Microsoft SQL Server 2005 to enable the SQL Server to run a database on a file system that is based on a CIFS share or an iSCSI target volume.

For more details, see the list of contents below.

Download the document as PDF.

Contents

• Summary
• Introduction
• Audience
• Methodology
  • Hardware and Software Components
  • Sun Storage 7000 Unified Storage System Administration: General Procedures
• Using a CIFS Share for a Microsoft SQL Server Database
  • Creating a CIFS Share on the Sun Storage 7000 Unified Storage System
  • Creating a Database on a CIFS Share
• Using an iSCSI Volume for a Microsoft SQL Server Database
  • Creating an iSCSI LUN on the Sun Storage 7000 Unified Storage System
  • Configuring the Microsoft Windows Server
  • Considerations While Using Windows File Systems on iSCSI Targets
  • Creating a Database on an iSCSI Target
• Glossary
• Revision History

For More Information

Here are some additional resources:

• Sun Storage 7000 Unified Storage System web site
• Sun BluePrints papers (registration required)
• Sun download site
• Sun training courses at http://www.sun.com/training/, for example, Sun Storage 7000 Unified Storage System Administration (NWS-6425)
• Forums:
  • Sun forums
  • BigAdmin Discussions collection
• Sun product documentation at http://docs.sun.com, such as Sun Storage 7000 Unified Storage System documentation
• Sun Documentation Center
• BigAdmin wiki:
  • Using Sun Storage 7000 Unified Storage System
  • Storage page
  • Databases page
• Resources on BigAdmin, such as:
  • Database resource collection (includes community content)
  • Storage resource collection (includes community content)
  • Feature Articles, with information on Sun Storage 7000 Unified Storage System
• Support:
  • Sun resources:
    • Register your Sun gear
    • Services
    • SunSolve Online
  • Community system administration experts
• Events of interest to users of Sun products:
  • Worldwide Developer Events and Sun Tech Days
  • Current Events

Unless otherwise licensed, code in all technical manuals herein (including articles, FAQs, samples) is provided under this License.