Backup and recovery concepts
This chapter describes basic concepts of backup and recovery of SQL Server and how NetBackup for SQL Server performs these operations.
“Overview” on page 49
“Protecting files and filegroups” on page 52
“Recovery considerations for files and filegroups” on page 53
“Reducing backup size and time by using read-only filegroups (SQL Server
” on page 54
“Recovery factors” on page 55
A SQL Server instance is created on a Windows host by installing Microsoft SQL Server. You can install multiple instances on a single host including a default instance and multiple named instances. You can select the database instance that you wish to browse and backup by selecting File > Set SQL Server connection properties.