Tutorials
SQL Server 2005In this tutorial you will learn how to take database backup in SQL Server 2005.
Sponsored Links
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.
Sponsored Links
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.
|
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 |
|
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 |
|
im new here i like this article i think it will help me thx |
| can we get the back up in our system harddrive it is possible to get the backup without any media? |
|
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 |
| How can we determine if taking backup is good or bad through t-sql command or not? |
|
In general you should always backup your database. I prefer using t-sql command over using management studio. Baghul |
| What is full backup in sql 2005 |
| How to take Backup of current modified table? |
| I want to take database backup of SQL 2005 at every 30 min. How to do it? |
|
Script out the backup config (you can create the specs in the wizard dialog) and make it a step in a Sql Agent Job. Schedule the job to run at that tempo. |
| What is the full Backup in sql server 2005 |
| This is my first time to employ sql server 2005.So my question is that how do i store all confidential data in encrypted format. |
| Thanks ... I am new for using SQL. I am able to backup database in SQL. |
|
hi i m manivannan In SQL Server 2005 my db name:a table name:a column name:a(varchar(max)),b(int) values a b hello|howdoudo|imfine|thanks 1 h|ho|ine|ths 2 helddlo|howdddoudo|imfiddne|tdhs 3 tell me the split stored procedure to get the table looks like this for i.e., when b=1 b=2 b=3 output output output a a a hello h helddlo howdoudo ho howdddoudo imfine ine imfiddne thanks ths tdhs |
|
hi i m manivannan In SQL Server 2005 my db name:a table name:a column name:a(varchar(max)),b(int) values a b hello|howdoudo|imfine|thanks 1 h|ho|ine|ths 2 helddlo|howdddoudo|imfiddne|tdhs 3 tell me the split stored procedure to get the table looks like this for i.e., when b=1 output a hello howdddoudo imfine b=2 output a h ho ine ths b=3 output a helddlo howdoudo imfiddne thanks tdhs |