My Sellerdeck Account | Free Trial

Sellerdeck Community & Knowledge Base

Go Back   Sellerdeck Community > Knowledge Base > Sellerdeck Enterprise

Search powered by Google
Register FAQ Members List Search Today's Posts Mark Forums Read

Thread Tools Search this Thread Rating: Thread Rating: 1 votes, 5.00 average. Display Modes
Old 11-May-2012, 11:28 AM
G.W.Green G.W.Green is offline
Join Date: Sep 2005
Full Name: G.W.Green
Posts: 485
Thanks: 0
Thanked 68 Times in 43 Posts
Scheduling automated backup using SQL server 2008

Schedule the database backup
  1. First login to Sql Management studio and connect to the required database. Now from the object explorer, make sure SQL server agent is running, if not start SQL server agent(Right click and press start).

  2. Expand the Management Node from the object explorer, and then select the maintenance plan node. To schedule maintenance plan, you need to have "SYSADMIN" database role. If you don't see the maintenance node, make sure you have the necessary permission.

  3. Right click the maintenance plan and then select "new maintenance plan".

  4. Enter the maintenance plan name in the popup box (This can be any name that identifies your task for ). This will identify your backup plan and you should choose a relevant name that suits your plan.

  5. Now you will be in the configuration page for the maintenance plan. . Note the marked area, these are the two areas you need to use for setting up the maintenance plan. The marked area in the right top will be used to configure the time that the plan executes. Choose a time so that the database is least used. The bottom left pane shows the tasks that can be utilized to create an sql maintenance plan.

  6. Click on the calendar item shown in the right side top. This will bring the job schedule properties popup window that configure the execution time/frequency of the tasks. Configure the data carefully so that it suits your requirement. Usually database backups are taken on a daily basis. Make sure you are selecting a proper time so that your database is least used. Click ok once you finish.

  7. From the maintenance plan tasks pane in the left side, select the backup database plan, this will be used to take backups for the databases. Drag and drop backup database task to the right side(as shown in the diagram).

  8. Double click on the backup database task, it will open up a new window that allows you to configure the database configuration for the backup. Here you configure the databases that you need to backup, then specify a location for the backup, specify the extension for the backup files etc.
  9. From the pop up modal window, by clicking on "Databases" dropdown, you will be able to select the required databases. Also configure the file location, extension for the backup file etc.

  10. Click ok once finished. Now backup plan configuration is over.

The backup files will be created on the scheduled time to the mentioned folder. The name of the file will be created by appending the date so that you can identify the back up for a particular date.

Backup File Maintenance

Since the backup files are created frequently, it is a good practice that you delete backup files after a certain period of time. For this you need to execute clean up task along with the maintenance plan. You can configure the clean up task as follows.
  1. From the left side pane, drag and drop maintenance cleanup task.

  2. Double click on the dropped item in order to edit the clean up properties. Here you need to specify the backup location, and file extension for the back up files and specify the age of the file. It is a good practice that you keep one month old data, and delete anything prior to one month.

  3. Once you click ok, then save the maintenance plan. You can either wait till the next execution time or execute it manually in order to check whether everything is working fine.
Attached Images
File Type: jpg SQLBackup.jpg (21.6 KB, 411 views)
File Type: jpg SQLBackup1.jpg (28.1 KB, 418 views)
File Type: jpg SQLBackup2.jpg (26.4 KB, 409 views)
File Type: jpg SQLBackup3.jpg (21.4 KB, 418 views)
File Type: jpg SQLBackup4.jpg (19.8 KB, 412 views)
File Type: jpg SQLBackup5.jpg (28.4 KB, 418 views)
File Type: jpg SQLBackup6.jpg (33.0 KB, 410 views)
File Type: jpg SQLBackup7.jpg (30.4 KB, 421 views)
File Type: jpg SQLBackup8.jpg (38.0 KB, 454 views)
File Type: jpg SQLBackup9.jpg (25.9 KB, 423 views)
Reply With Quote

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

All times are GMT. The time now is 01:06 AM.

Powered by vBulletin® Version 3.8.4
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.