Sponsored Links
SQL Server 2005 Tutorials
- SQL Server Integration Services
- 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
Tutorials
SQL Server 2005SQL 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.
Comments
Robert F. said:
|
Hi I am using SQL 2005 standard edition and upgraded to SP2. When i want to backup and schedule like this tutorial i am not getting the same screen as in Fig77.JPG. Refresh and Schedule are not an option for me, are you using something else than i have here? Thanks, Robert |
Matt said:
|
My schedule button is missing too, from what I've found on searching maybe that was something in a pre-release version of SQL Server 2005 Management Studio. But Scheduling is still available - click the dropdown icon next to Scripts to see the Script options and choose "Script Action to Job" this allows you to schedule the data and times of the backup, send emails when its completed and lots of other things. This article helped me: http://support.microsoft.com/kb/930615 |
riya said:
|
im new here i like this article i think it will help me thx |
Gopal said:
| can we get the back up in our system harddrive it is possible to get the backup without any media? |
Ajesh Joseph said:
|
I am using HP DAT 72 . But in my SQL 2005 server tape option is hidden in backup option. How to enable that. Pls me Thx |
Sponsored Links
