Storing Microsoft SQL Server Databases on the NAS 8000

executive summary ....................................................................................................................2
for more information..................................................................................................................2
hp solution overview..................................................................................................................4
storage management and definition guide..............................................................................5
defining NAS 8000 storage for Microsoft SQL Server databases.......................................5
NAS 8000 security level guidelines...........................................................................................6
preparing SQL Server to utilize the NAS 8000 ........................................................................6
enabling networked storage on SQL Server.........................................................................6
setting the service owner for SQL Server ..............................................................................7
installation of Microsoft SQL Server software..........................................................................7
installation of SQL Server on the NAS 8000.........................................................................7
installation of SQL Server on a Windows Server .................................................................7
addressing the NAS 8000 from the SQL Server ......................................................................7
Universal Naming Convention................................................................................................7
mapped network drives .........................................................................................................8
preferred method for specifying access points/shares........................................................8
creating new database(s)...........................................................................................................8
share level security..................................................................................................................9
user level security ....................................................................................................................9
creating a database with the SQL Server Enterprise Manager utility.............................9
creating a database through SQL Scripts...........................................................................9
moving data files from already existing databases............................................................9
database management ............................................................................................................10
performance tuning ..................................................................................................................10
increasing available storage in the NAS 8000 ......................................................................10
adding hard drive(s) to the VA 7xxx array .......................................................................11
backups......................................................................................................................................11
nvram usage and nvram failures............................................................................................12
problems, challenges, and constraints ...................................................................................13
storage diagram for VA 7100.................................................................................................14
storage diagram for VA 7400 (single volume group)...........................................................15
storage diagram for VA 7400 (extra fault tolerance)...........................................................16
glossary .....................................................................................................................................17
3