SnapManager® 2.1 for Microsoft® SQL Server™
Installation and Administration Guide

View in Frames

Preface

Chapter 1: Understanding SnapManager
Overview of SnapManager for Microsoft SQL Server
Terms and technologies
How SnapManager for Microsoft SQL Server works

Chapter 2: Preparing to Install or Upgrade SnapManager
What to read
Verifying Windows host system requirements
Verifying storage system requirements
Preparing a Windows host system for SnapManager installation

Chapter 3: Installing or Upgrading SnapManager
Installing SnapManager on a stand-alone Windows host system
Installing SnapManager into an MSCS environment
Upgrading to SnapManager 2.1
Uninstalling SnapManager
Reinstalling SnapManager

Chapter 4: Starting SnapManager for the First Time

Chapter 5: Understanding Volume Mount Point
Understanding NTFS volume mount point
Understanding SnapManager support for volume mount points
Backup and recovery using volume mount point

Chapter 6: Preparing to Migrate SQL Server Databases
SQL Server configuration rules with SnapManager
SQL Server configurations supported with SnapManager
Assessing volume size

Chapter 7: Using the SnapManager Configuration Wizard
How databases are stored on storage system volumes
Understanding the Configuration Wizard
Migrating SQL Server databases to LUNs
Moving multiple SnapInfo directories to a single SnapInfo directory
Migrating SQL Server databases back to local disks

Chapter 8: Understanding SnapManager Backup Sets
How SnapManager Backup works
Types of backup operations performed using SnapManager
How SnapManager checks database integrity in backup sets
How SnapManager backup data is organized
Ways to manage the number of backup sets kept online
When to run a SnapManager backup

Chapter 9: Backing Up Databases Using SnapManager
How SnapManager backup functions are accessed
Creating a full database backup using SnapManager
Creating a transaction log backup using SnapManager
What to do if a SnapManager backup operation fails
Performing database verification using SnapManager
Using backup management groups in backup and verification
Explicitly deleting backup Snapshot copies using SnapManager

Chapter 10: Restoring Databases Using SnapManager
SQL Server 2000 and 2005 recovery models
Understanding SnapManager Restore
Types of SnapManager restore operations
Choosing the type of restore operation to perform
Performing a restore operation
Managing databases mounted at or restored to alternate locations
Deleting restored Snapshot copies

Chapter 11: Managing SnapManager Operational Reports
Understanding the SnapManager Reports tab
Viewing a SnapManager report
Printing a SnapManager report
Deleting SnapManager reports

Chapter 12: Replicating Backups to Mirrored Volumes
Understanding SnapManager backups with SnapMirror updates
Minimizing your exposure to loss of data
Scheduling SnapManager backups with SnapMirror replication

Chapter 13: Archiving SnapManager Backups
Understanding SnapManager backup set archival
Choosing the best way to archive
Archiving SnapManager backups using NDMP or dump
Archiving SnapManager backups using a Windows backup utility
Automatically archiving SnapManager backups using SnapVault

Chapter 14: Performing Disaster Recovery with SnapManager
Guides you should read and have at hand
Preparing for disaster recovery
Backing up your SQL Server environment
Replicating your SQL Server environment
Restoring your SQL Server environment
Recovering SQL Server databases using SnapMirror
Recovering SQL Server databases using archives
Restoring a storage system volume using backups archived with SnapVault
Recovering a failed SQL Server computer
Recovering both a failed storage system and a failed SQL Server computer
Restoring databases from other SQL Server backups
Restoring system databases from SnapManager backup sets

Appendix A: Tools for Managing Backup and Verification
Using the Run Command After Operation feature
Scheduling a backup job or a database verification job

Appendix B: SnapManager Command-Line Reference
Guidelines for using the command-line utility
SmSqlBi syntax

Appendix C: Configuring SnapManager Application Settings
Overview of SnapManager application settings
Connecting to an SQL Server instance
Changing the SQL Server user account
Database integrity verification options
SnapManager backup options
SnapManager restore options
Run Command After Operation default settings
Managing fractional space reservation
Enabling or disabling database migration back to local disks
SnapManager report directory options
Event notification options

Appendix D: Configuration Wizard Screens and Dialog Boxes
Using the Database Verification Server and Account Authentication screen
Using the Where to Move Databases screen
Using the Number of Databases that Can Be Backed Up Concurrently screen
Using the Modify SQL Server Maximum Worker Threads Parameter screen
Using the Specify a Single SnapInfo Directory screen
Using the Where to Put the Default SnapInfo Directory for Each SQL Server Instance screen
Using the Where to Put the Default SnapInfo Directory for LUNs Shared by Multiple Databases screen
Using the Where to Put the SnapInfo Directory for Each Database screen
Using the Database Migration Options screen

Appendix E: Configuring Post-Restore Database Recovery
Understanding post-restore database recovery states
Specifying the post-restore state of a single database
Specifying the post-restore state of multiple databases

Index

Legal Information

SnapManager® 2.1 for Microsoft® SQL Server™ Installation and Administration Guide

SnapManager® 2.1 for Microsoft® SQL Server™
Installation and Administration Guide