11-11
24

Adjust SQL backup schedule for SQL 2000/2005/2008

Fine Happy

AuthorEASEUS   Category Data Backup   Comments0   Post Time 2011-11-24 21:12:47 -0500

This article describes how to schedule a database backup operation by using SQL Server Management Studio and SQL backup and recovery software. Here we take SQL Server 2005 for example, show you how to schedule a database backup operation by using SQL Server Management Studio?

Using SQL Server Management Studio:

See free backup SQL Server database with SQL Server Management Studio.

To schedule a database backup operation by using SQL Server Management Studio in SQL Server 2005, follow these steps:
1.Start SQL Server Management Studio. In the Connect to Server dialog box, click the appropriate values in the Server type list, in the Server name list, and in the Authentication list. Click Connect.
2. In Object Explorer, expand Databases. Right-click the database that you want to back up, click Tasks, and then click Back Up.
3. In the Back Up Database - DatabaseName dialog box, type the name of the backup set in the Name box, and then click Add under Destination.
4. In the Select Backup Destination dialog box, type a path and a file name in the Destinations on disk box, and then click OK.
5. In the Script list, click Script Action to Job. In the New Job dialog box, click Steps under Select a page, and then click Edit if you want to change the job parameters.
Moreā€¦

Using SQL backup and recovery software
:

Free MS SQL Server backup solution: EaseUS Todo Backup Advanced Server is professional backup software for SQL Server 2000, 2005, 2008. You can backup database with schedules to do automatic SQL backups.
Detailed backup steps refer to 
backup guide of SQL backup.
You can choose right solutions suit your situation from 
Backup SQL Server.
Free download SQL backup software now to create SQL Server disaster recovery plan.

Trackback URL Trackback: http://blog.easeus.com/action.php?action=tb&id=515

Tags Tags: sql backup and recovery software,adjust sql backup schedule

Comments List

Post a Comment

  • Name:
  • Email:
  • HomePage:
  • Comment:
  • Question:

Home | Solution | About Company | Contacts | Resource | Blog | Forum | Directory | Links | Sitemap

Copyright © 2005-2008 CHENGDU YIWO Tech Development Co., Ltd. ALL RIGHTS RESERVED.

Privacy Policy | License | Legal Counsel