Technical Training
SQL Server 2005 TrainingSQL Server 2005 - Database Backup
SQL Server 2005 - Database Backup
In this tutorial you will learn how to take database backup in SQL Server 2005.
The database created above can be backed up at periodic intervals using the Backup Database dialog box in SQL Server Management Studio. The file gets stored in the .abf format. To display the Backup database dialog box right click a database in the Object Explorer and select Tasks > backup.
The following dialog box appears
The Database is the name of the currently selected Analysis Services database. They type of recovery will have to be specified. A timestamp for expiry of the database will have to be specified. Finally the destination will have to be specified. Under options the user will have the option to overwrite on a media or append to an existing database file. He will also be able to set an option to check media set name and backup set expiration or backup into a new media set and erase all backup sets. He will set options for verifying the backup when the operation is complete and perform a checksum before writing to the media. He can maintain transaction logs and write to a tape media and unload the tape after writing. Once he has set the options he can create the backup by selecting OK.
The backup is commenced and on completion, a message box is displayed as under signifying the success of the operation.
Click OK to exit the message box.
Till now we have examined in detail the SQL Server Management Studio and the various Administrative tasks that can be performed by the DBA using the interface.
SQL Server 2005 Training
- SQL Server 2005 - Configuring Replication
- SQL Server 2005 Replication Enhancements
- SQL Server 2005 - Mirror Server
- SQL Server 2005 - Introduction to Data Availability
- SQL Server 2005 - Backing up a Database
- SQL Server 2005 - Using Database Snapshots
- SQL Server 2005 - Disaster Recovery
- SQL Server 2005 - Managing Certificates
- SQL Server 2005 - Managing Permissions
- Managing SQL Server 2005 Security
- SQL Server 2005 - Using the Database Tuning Advisor
- SQL Server 2005 - Tuning a Database
- Maintain indexes in a SQL Server 2005 database
- SQL Server 2005 - Defining Indexes
- SQL Server 2005 - Database Backup
- SQL Server 2005 - Populating the Database
- SQL Server 2005 Configuration Manager
- SQL Server 2005 - Using the Sqlcmd Utility
- Using the SQL Management Objects
- Using SQL Sever Management Studio - Part 2
- Using SQL Sever Management Studio - Part 1
- SQL Server 2005 - Using Event Notifications
- SQL Server 2005 - Using DDL Triggers
- SQL Server Monitoring Tools - Server Profiler
- SQL Server 2005 - Testing Troubleshooting
- SQL Server 2005 - Upgrading from earlier versions of SQL Server
- SQL Server 2005 Installation - Maintenance Plan Without Using Wizard
- SQL Server 2005 - Unattended Installations
- SQL Server 2005 Installation - Maintenance Plan Using Wizard
- Installing a Second Copy of SQL Server 2005
- Planning to Install SQL Server 2005
- SQL Server 2005 Installation
- SQL server 2005 Editions
- SQL Server 2005 Architecture Overview
- SQL Server 2005 - Management studio interface Summary Page
- SQL Server 2005 - Server Groups
- SQL Server 2005 - Registered Servers
- SQL Server 2005 Administrative Tools
- Developing Client applications in SQL Server 2005
- SQL Server Management Objects
- NET CLR in SQL Server 2005
- Native HTTP Support in SQL Server 2005
- XML Data Types in SQL Server 2005
- Using XML in SQL Server 2005
- Using Notification Services in SQL Server 2005
- SQL Server 2005 - Service Broker
- Data Manipulation Language (DML) in SQL Server 2005
- T-SQL Enhancements in SQL Server 2005
- Security Features in SQL Server 2005 for the Developer
- SQL Server Architecture and Components
- SQL Server 2005 Management Studio
- Overview of SQL Server 2005 for the Database Developer
- Getting started with SQL Server 2005







