10.2. Perform Backup Operations
As with most tasks in SQL Server, you can do backup and restore operations by using either the SQL Server Management Studio (SSMS) visual interface or Transact SQL (TSQL) code. In the following sections, we will show you both techniques for performing backup operations.
NOTE
There are numerous third-party utilities that you can use to assist you in managing SQL Server backups. Most of these have their own tools and interfaces that you would use to take backups and perform restores. The rest of this chapter applies only to the SQL Server built-in toolset for backup and restore and does not directly apply to any of these third-party environments.
10.2.1. Perform Full Database Backups
A full database backup is ...
Get SQL Server® 2008 Administration: Instant Reference now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
