Data Management
The chapters in this part show you how to transfer data to and from a SQL Server and how to back up and restore databases.
-
Chapter 11, Exporting and Importing Data, shows you how to use SQL Transfer Manager and the bcp utility to transfer data to and from a SQL Server. It also tells you how to create SQL Scripts (which are files containing the statements used to create database objects).
-
Chapter 12, Backing Up and Restoring, shows you how to back up a database or transaction log, how to restore from a backup, how to truncate the transaction log, how to schedule backup tasks for automatic execution, and how to recover from storage media failure.